- My Top 10 Power BI Tips7th November 2022I’ve just realised that in all the 7 years I’ve been writing blogs on Power BI, I’ve never written the most obvious blog of all and that is a “Top Tips” one! To remedy this situation, here are my 10 favourites. I hope you'll find these tips as useful...
- Total Row Grief – When Your Measures Don’t Sum in the Total Row28th October 2022On the Microsoft Power BI Ideas Forum ( https://ideas.powerbi.com/ideas/), there is a long-running request (since July 2018) that has amassed a modest...
- Making a Slicer Highlight Rather than Filter21st October 2022So you think a slicer can only filter data in a visual: - Right? Wrong! Just look what I’ve done! If you want a slicer to highlight data in your...
- When Single Directional Filtering Appears Not to Work21st October 2022One of the major factors that underpins a good Power BI data model is when filters only propagate from the one side of a relationship to the many...
- Visualising the Next or Previous N Months from a Selected Month11th October 2022Ever wanted to do this? S elect a month in a slicer and then visualise in a column chart the next 5 months’ sales from that date. Or show the previous...
- Using Dynamic Values in the Smart Narrative and Text Box3rd October 2022When you want to summarise key metrics in your report, the go-to visual you will probably use is the ubiquitous card visual. However, if you knew how...
- Why Do I Need a Date Table in My Data Model?26th September 2022The following is an extract from Alison's book 'Up and Running with DAX for Power BI' Have you ever wanted to compare sales for the current month...