Brisbane, 4000 QLD

+61 4 3836 7017

Blog

Strategic colouring in Power BI – Part 1: Comparing different metrics across a common dimension

This is the first post in the Strategic colouring in Power BI series. Links to all the posts can be found here https://capstoneanalytics.com.au/master-post-for-strategic-colouring-articles/ So you work in Sales. You want to compare revenue, profit, tax amount over the different business units. You want to see the relative position of a ...

Analytics use cases for the mining industry – Part 2: Industry Intelligence

Wouldn't it be great if you had access to reliable and accurate mining intelligence data that was not static. Imagine the possibilities of a rich, interactive mining intelligence report that gave you instant insights on your fingertips. This is what the report aims to do. Its a report on Queenslands ...

Creating horizontal and vertical multiples in a single visual in Power BI

Did you know that is very easy to create horizontal and vertical multiples in a single visual in Power BI ? Watch the video to see how to use the Infographic Designer custom visual to achieve this. Adventureworks dataset was used ...

Working with charts with drilldown options in powerbi ?

Ever had a situation with a drilldown chart where you click on an individual bar at the top level and you go one level down but you don't know what the top level attribute is ? Watch this video to see how enable a single feature which allows you to ...
/ Drilldown, Power BI, Power BI

What does Pink Floyd teach you about data visualisation ?

So finally an article about my favourite band that connects to what I do for a living. For those who know me I'm a HUGE Floyd fan and though I'm not old enough to have seen them live I have watched Roger Waters perform five times and even flew all ...
/ Legacy, Pink Floyd, Power BI, Space, Visualisation

Can you password protect a Power BI report ?

You cannot password protect a Power BI report natively. However there are some hacks which you can use which simulates password protection. However these can easily be "unhacked" so please do not use these techniques on client sensitive data. This is more of an academic exercise and hence worth writing ...
/ DAX, Drillthrough, Password, Power BI, Power BI