As you develop your Power BI reports, making sure that your visuals are showcasing the insights you need is very important. The great thing is that this is very easy to do and can make your dashboard really pop and keep your consumers happy. You have a few options when it comes to your visual
Category: Data Modeling
Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out that much more intuitive. I keep thinking back to using VBA with these variables. They make your life in VBA about ten times easier – and the same
When using Power BI you sometimes think you are limited to the data sitting within your tables. Well with Power BI that is certainly not the case. You have tremendous flexibility to build on top of your data by bringing in values from additional tables to flex the numbers or stress your results with scenarios.
The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a
I wanted to be able to drill into a specific subset of my customers – in this particular case – I decided to delve into the top 20% as it was most relevant to my analysis, and follows on from a previous tutorial about the Pareto principle – also known as the 80/20 rule. Not