Sometimes it is not too efficient to manually adjust the DAX code of the Field Parameters and create a column for grouping. Let’s say when you have more than 8-10 fields, you are probably better off with some dynamic grouping. Read more…
With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to Read more…
With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports. But with great powers comes great responsibility… In other words, if you add lots of fields to Read more…
Full Calendar vs Trimmed Calendar We all know that having a Date Table in Power BI is a must to achieve reliable and good Time Intelligence functions and measures. But did you know that these measures could work with both Read more…
What options do you have when something goes wrong with a Dataflow in Power BI? Well, there are quite a few options to use and each offers a different way of handling problems. If you want to learn more check Read more…
Today I would like to present two “issues” that I reckon many of you faced before. The first one is sorting month names chronologically in a custom Calendar/Date table, and the second one is sorting customers based on a custom sort Read more…
Today I am going to tackle a problem that doesn’t involve sales-related data. Why? Because not all Power BI reports should be about sales figures. Let’s say that I am the owner of a popular mall here in Sydney. One Read more…
Do you know what happens when you refresh a Dataflow in Power BI Service? First of all, there are two types of Dataflow refreshes; Full and Incremental: In this tutorial I focus on Full Dataflow refresh. I think most report Read more…
So you already know how to use Cloud-based data sources to connect to your Dataflow, but there is a need to expend to files or folder on your PC. I know how you feel; and I can guarantee that this Read more…
If you ever used the default treemap visual in Power BI, you probably already know that it has a bunch of wild colors – depending on the theme you are using. And it is very similar to the pie chart Read more…