Subscription Pattern in Power BI – DAX Measure for Active Subscribers or Open Tickets For All Dates

One of the common patterns of a data model is the subscription pattern. In this pattern, we have subscriptions (or tickets, or issues, or whatever else you want to call it) open date and close date. The way that this data is stored in a table makes it a bit challenging to get informative insight Read more about Subscription Pattern in Power BI – DAX Measure for Active Subscribers or Open Tickets For All Dates[…]

Calculating Stock on Hand Using DAX: Power BI Inventory Model

You don’t have always the luxury of having a snapshot fact table that has the stock on hand value for every single day, at every single workshop, and for every single product. Even if you want to build such a table, it can get easily gigantic. In this blog post, I am going to show Read more about Calculating Stock on Hand Using DAX: Power BI Inventory Model[…]

Calculating Total, and Percentages in a Row-Level Security Power BI Model

I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare Read more about Calculating Total, and Percentages in a Row-Level Security Power BI Model[…]

Why My Values are Not Showing Correctly in Power BI?

I have written previously about what is a fact table, and what is the dimension table, and how they relate to each other in a Power BI data model. However, still I see when people use these tables in their model, they get ambiguity of what table should be used for what, and if they Read more about Why My Values are Not Showing Correctly in Power BI?[…]

Custom Format Fields and Measures in Power BI

If you have been watching Power BI news recently, you know that Power BI fields now support custom formatting. In this short blog article, I am going to explain how to use this feature to achieve your custom formatting. You can do things like showing () for negative values, showing custom date/time formats, and etc. Read more about Custom Format Fields and Measures in Power BI[…]

Using Data Category to Have a Better Visualization in Power BI

There are some field properties in Power BI such as formatting, which is obvious to use. However, some configurations on the field level, such as Data Category, is not very well known. Data Category is a configuration that can be helpful in multiple visualizations, In this short article, I’m explaining how to use this option Read more about Using Data Category to Have a Better Visualization in Power BI[…]

What Fields to Hide in Your Power BI Solution?

To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solution very tidy and clean and easier to maintain. However, you might wonder what are fields that have to be Read more about What Fields to Hide in Your Power BI Solution?[…]

Budget vs. Actual Model in Power BI: Calculations and DAX

In the previous article, I explained how you can build a data model for budget vs. actual, where the grain of the two fact tables is different. The model works perfectly as a star schema. As long as you slice and dice data in the level of granularity that both tables support, then you don’t Read more about Budget vs. Actual Model in Power BI: Calculations and DAX[…]

Budget vs Actual: Zero Complexity Model in Power BI

When I explain the Star Schema and best practices of data modeling in Power BI, Often I get questions such as what if we want to have budget and actuals in the same data model? what if there are two tables with different granularity? We cannot solve it with simple data modeling and relationships, this Read more about Budget vs Actual: Zero Complexity Model in Power BI[…]

Why my Power BI Matrix or Table Visual is SLOW

You have created a Power BI report with many visualizations and calculations, however, it is slow! And the slowest part of that is the report page with a matrix or table visual in it! Why that visual is so slow? Is this the problem of Visual in Power BI? or Power BI problem at all? Read more about Why my Power BI Matrix or Table Visual is SLOW[…]