Fixing The ALL Function
If you use an ALL function on a column that has a sorting by column applied, you also need to take that sorting column into account.
Format DAX
You can format all your DAX measures at once. No more single-handed formatting every measure one by one. To format all your measures at once you will need Tabular Editor 2 (free). You can then run the c# script:Model.AllMeasures.FormatDax();
Keyboard Shortcuts
Power BI desktop has a lot of keyboard shortcuts. This can make your life so much easier when you are developing on a Power BI Report. I myself always use Ctrl + Shift + L (select all occurrences of current selection in a DAX measure). But there are so much more shortcuts which could help […]
Field Parameters
Do you want to change the fields in your table visual or matrix visual by slicer selection? Did you know you can use the option field parameters for this. Field parameters gives you the option to choose your fields by slicer selection. Assume that your data model would look something like this. You have a table with […]
Resources Excedeed
Did you ever run into the error where your visual exceeded resources? I wrote this article to help you with this error. But before we start it is important to know what causes this error. Root cause Behind all the Relationships, DAX queries, Filters and Shiny Visualizations in Power BI there is code (queries). That code is making sure that everything you have […]