Query Editor – Applied Steps
Query Editor in Power BI and Excel PowerQuery allows you to see what has been done on the screen’s right-hand side. These Applied Steps are invaluable especially when suddenly something stops working; this can happen when you’re doing your initial build although it is most likely to occur when your refreshes have been running for a long time. So suddenly your refresh fails, and you need to track down the issue. Knowing and accepting that this is normal is a vital thing for you as grow in your capabilities.
Get the data – email enquiries@geordieintelligence.co.uk – this is part of our training dataset.
Report Layer – Conditional Formatting
When you present data, you can use conditional formatting to highlight values, you can use them to expand on the visibility and highlight values and show banding. In the video, we used the DAX below to determine if the value shown was the Mean, Median or Modal value, although the only real limit is your imagination.
Colour Select = VAR Mod = CALCULATE([Modal Average], KEEPFILTERS(VALUES(Offers[(case)_LoanGoal])), All(Offers)) VAR Med = CALCULATE( [Median Amount], KEEPFILTERS(VALUEs(Offers[(case)_LoanGoal])),All(Offers)) VAR Test = SELECTEDVALUE(Offers[(case)_RequestedAmount]) Return If ( Test = Mod, 1, if ( test = Med, -1, 0))
Get the data: https://github.com/scheithauer/processmining-bupaR/