Display Active Slicers in Power BI using Dynamic DAX
Learn how to enhance visibility using slicers in Power BI for better report filtering and user experience.
Kenneth A. Omorodion is a Microsoft Certified Solutions Associate (MCSA) with 12+ years of enterprise application experience in Power BI, DAX, Microsoft Fabric, Business Intelligence, data warehousing, SSRS, T-SQL, and Azure. Beyond his technical skills, Kenneth has expertise working with stakeholders’ and business leaders to help them better understand key insights. He has a great track record of successfully delivering full life cycle Business Intelligence and data solutions to organizations with measurable business impact.
- MSSQLTips Awards
- Achiever Award (75+ Tips) - 2025
- Author of the Year-2021
- Author Contender-2022/2023/2024
Prevent Future Date Spillage in Power BI Visuals
Solve the frustrating date spillage issue in Power BI. Discover techniques to prevent measures from spilling into future dates.
Implement Snapshot Reporting in Microsoft Fabric using Fabric Pipelines
Learn how to implement snapshot reporting using Microsoft Fabric Dataflow Gen2 using Microsoft Fabric Pipelines with step-by-step instructions.
Track Historical Changes in Microsoft Fabric using Dataflow Gen2 Snapshots
Learn how to use Microsoft Fabric Dataflow Gen 2 to create data snapshots for historical and comparison reporting.
A Practical Guide to Implement Data Quality Rules in SQL Server
Explore critical data quality rules and learn to implement them without pre-built tools by using SQL scripting techniques.
Simplify Data Quality Validation with SQL
Learn about Data Quality Validation using TSQL in achieving reliable data for effective business intelligence and analytics processes.
Power BI Custom Calendars for Gregorian, Fiscal, Retail, 13-Month, and Lunar
Discover the benefits of Power BI custom calendars and how they enhance time intelligence reporting with new DAX capabilities.
Building a Dynamic Countdown Timer in Power BI
In this article, we go over how to build a dynamic Power BI countdown timer visual to be added to your reports and dashboards.
SQL Server Triggers for Business Rules Automation
In this article, learn how SQL Server triggers can be used for business rules regardless of how the data is inserted, updated or deleted.
Power BI Deployment Pipeline Features
This tip provides insights into common questions relating to Power BI Deployment Pipeline features and what you should know.
How to Sort Combo Box Values in a Power Apps Canvas App
Learn how to sort the values in a Power Apps combo box to ensure the values are sorted to make it more user friendly.
Power BI Workspaces Management and Archiving Best Practices
This tip explains Power BI best practices for workspace management, including archiving, and cleaning for an efficient Power BI environment.
Optimize Delta Tables with VACUUM in Microsoft Fabric
Learn how the VACUUM operation in Microsoft Fabric enables you to manage storage and preserve integrity of partitioned Delta tables.
Data Retention Management for Lakehouse Files in Microsoft Fabric
In this article, I describe how data storage can be managed when the data exists as files in Microsoft Fabric Lakehouse.
Partitioning Data in Microsoft Fabric to Improve Performance
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimensions
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
Design Data Warehouse with Medallion Architecture in Microsoft Fabric
This article outlines an end-to-end approach to designing a data warehouse using Medallion Architecture in Microsoft Fabric in this article.
Power BI Export to Excel
Learn how you can export millions of rows of data out of Power BI to either a CSV or Excel file.
Slice Data by Fiscal Month using DAX for Power BI Reports
In this article, learn how to set the current fiscal month identity in a calendar table using DAX for Power BI when dealing with fiscal periods.
Dynamically Display Top N and Bottom N Records in One Power BI Chart
This article will demonstrate the step-by-step process to dynamically display the Top N and the Bottom N records in the same Power BI chart.
Sort String Date Values on a Power BI Slicer Visual
In this article, we look at how to build a slicer visual in Power BI and how to create a custom sort order for the slicer values.
Rank and Sort Data Based on Multiple Columns in Power BI with DAX
This article describes two approaches to allow you to rank and sort data based on multiple columns in Power BI.
Simplify Data Merging in Power BI with DAX NATURALINNERJOIN
DAX offers a powerful function, NATURALINNERJOIN, to streamline the process of combining data and merging tables in Power BI.
Dynamically Create Tables in Power BI with DAX Functions
Learn about DAX functions to use in Power BI ADDCOLUMNS, CROSSJOIN, VALUES, SUMMARIZE, GENERATE, CALENDAR, FILTER, TOPN, UNION, and NATURALINNERJOIN.