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. One of the easiest (and probably best) ways to do 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 the Parameter Table in Power BI it will be difficult 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 the Parameter Table in Power BI it will be difficult 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 a Full Calendar and a Trimmed Calendar? In today’s video, 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 order. So, you have followed a Power BI Best Practice 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 and donut chart coloring rules. But if you want to Read more…
That’s exactly the question I had in my mind when I started preparing for this tutorial… Then I realized that the best example or use-case for a Visual Header Tooltip is sharing a secret key with our users. Meaning that I also had to share some ideas about Data Masking Read more…
I think we all know that finding the right amount of visuals, the best visual representation of data points and in general, creating a good design in any Data Visualisation tool can be challenging. Sometimes I still struggle to show enough to my report users without overcrowding a report page. Read more…
Firstly, let’s tackle the elephant in the room. Starting our journey with Power BI is not simple. It is true for report creators and report consumers as well. Our responsibility – as report authors – does not stop at publishing a report or dashboard. We also have to do our Read more…
Sometimes it could be challenging to find the best way to visually present our data, but luckily there are some great materials online to follow. But what happens when we are unsure about the whole User Interface (UI) or User Experience (UX)? It’s not as straightforward as picking the right Read more…