How to show the sum of non-selected categories grouped together as “Other” category in visuals

I recently came across an interesting problem regarding how you can show the sum of values of certain selected categories as separate bars in a bar chart - but with the sum of all the non-selected categories being grouped together…

Create a basic Date table in your data model for Time Intelligence calculations

In this blog post, I am going to show you how you can quickly add a very basic Date table to your model. You might be wondering - why do you need a Date table? A Date table is very…

How to sort values in ascending order with BLANK values at the bottom

In this blog post, I want to share with you all a trick that I recently used to meet one of my client’s requirements. Basically, they wanted to see a very simple table that showed Sales by Category, and they…

Dynamic title/measure based on what is NOT chosen in a #powerbi Slicer

A few months ago, a very interesting question was posted on the Power BI community forum and I had the opportunity to work on it. Finally, I have the time to write a blog post about this so that we…

Implement Row Level Security based on business rules in Power BI

Here is another interesting use case of Row Level Security (RLS). It's funny that my first post was also about RLS - when you use RLS, lot of different challenges show up (which are not relevant and do not have…