• My Top 10 Power BI Tips
    7th November 2022
    I’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 Row
    28th October 2022
    On 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 Filter
    21st October 2022
    So 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 Work
    21st October 2022
    One 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 Month
    11th October 2022
    Ever 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 Box
    3rd October 2022
    When 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 2022
    The 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...