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 341 votes to date. What is this request you ask? Here it is:- “It would be great if Grand Totals on...
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? Select 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...
Power BI user interface experiments1st September 2022It looks like Microsoft is once again making some changes to Power BI’s user interface. Currently, (September 2022) we are seeing several different...
Blog
As Microsoft software evolves and new opportunities to enhance your data visualisation and integration evolve through Power BI, we like to keep you up to date. Our blog not only looks at new developments but shares consultancy news and training opportunities. Sign up to our blog to stay in touch.
