Power BI Experts
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…
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…
Read More Create a basic Date table in your data model for Time Intelligence calculations
The May 2020 Power BI update (which was released today, May 19th, 2020) has a new feature that allows you to set a shadow around your visuals. I had a little bit of fun testing out this feature; I used…
Read More Illuminate KPI cards with new shadow feature and conditional formatting
As you know, we can get data in all forms and shapes and sometime it's simply NOT possible to use the data directly as we receive it. In these cases, Power Query comes to our rescue to help us shape…
Read More Transform Data in Power Query using the Unpivot and Pivot Functions
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…
Read More How to sort values in ascending order with BLANK values at the bottom
Relative date filtering is a great way to filter your data while keeping the current date in context. I’m sure you may have used this feature many times before and find it very valuable - but it doesn't always meet…
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…
Read More Dynamic title/measure based on what is NOT chosen in a #powerbi Slicer
Sometimes we have data for many years in our dataset, but we want to restrict how many data points we want to show in #powerbi visuals at any given point. In this blog post, I talk about how you can easily achieve this with a few #dax measures!
More than a year ago, a question was asked on the Power BI community in regards to showing a heat map in Power BI. Not just a simple heat map in the matrix visual, but a heat map based on…
Power BI is an amazing tool as it fulfills all level of BI needs, whether you are using it for data exploration, as self-service BI to analyze the data, as an Enterprise BI solution, or embedding into your internal or…
Read More Self-serve data prep at lightening fast speed with Power BI dataflows and Azure Data Lake