Brisbane, 4000 QLD

+61 4 3836 7017

test-post

Changing bookmark button behaviour using disconnected tables and DAX

Bookmarks are a great way to story tell in Power BI as they can be used to save pre configured states in a report. However they have drawbacks in that you have to create two versions of a button for each bookmark and show/hide one of them depending on the bookmark...

Transforming a heatmap using a single line of DAX

Heatmaps are a great way of showing complex data in an easily understandable manner. In a heatmap, you have rows and columns and at the intersection of each row and column you have a value. Typically you are not interested in the individual values and want to see the...

Transforming a line and column chart

In this post we will discuss how to transform a basic line and column chart into a chart which prompts the user to take action. We have line and column chart below which shows daily sales as columns and an average daily sales line (Day number of month as Axis and...

What is the ROI of a dashboard – Part III – The Return of Hope

In the previous post we saw how duplication of effort was one of the biggest issues facing companies which are deploying a Power BI solution. Duplication of effort leads to: Wasted hours - Time spent on duplicating dashboards can be spent on more value add work No...

What is the ROI of a dashboard – Part II – The Point of No Return

In the previous post I talked about the definition of ROI for a dashboard which is Time spent on developing an automated dashboard / Time spent on developing it manually Now consider an example of developing an Employee Hours dashboard where you want to track the...

What should be the purpose of a dashboard ?

What do you think should be the purpose of a dashboard? At the very least a dashboard should Inform • Sales dashboard informs the user on revenue, KPI etc • HSE dashboard informs the user on safety incidents , actions etc • Use visuals and text to Inform Clarify •...

What is the ROI of a dashboard ? – Part I – The Return

Not an easy question to answer, is it. Subjective terms like "better insights" or "improving decision making" don't really cut it as they cannot be measured Ideally you would want the dashboard that you have developed to increase revenue/decrease costs/reduce risk....

What do you do when someone shares a Power BI report with you ?

If you have never used Power BI, you fumble around trying to make sense of it and waste 30min of your life and then give up. What if I showed you a technique to browse a Power BI report efficiently and make your life easier. It’s called the FBI technique. Why FBI ?...