test-post
Change line colour based on values in a disconnected table
Power BI works on great relationships, but sometimes we need to solve a problem without any relationships. Enter the disconnected tables. These are very useful to solve specific problems. They are easy to set up and you can be as creative as you want with your DAX to...
Get users to select the colours in your reports
Deciding which colours to use in a report is never an easy decision as each one of us has our own preferences. Someone will always be disappointed with the choice of colours used in your reports. One way around this is to conduct a survey of the colours to use in a...
Data storytelling by using the Page Navigation button
Data storytelling is increasingly being seen as essential to modern data analysis It is no longer enough to just develop a data model and produce visuals and let the audience take it from there. Reports need to be developed with the end user in mind while taking them...
How to sort a 100% stacked bar chart by % values
By default the 100% stacked bar chart is sorted by the actual value. But that's not very useful as its hard to see what is the top category by %. Fortunately you can achieve the sorting by % value by an easy tip. And it doesn't involve creating calculated columns and...
Strategic colouring in Power BI – Part 3: Isolating a category in a trend
This is the third 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/ In the previous post we saw how to compare a trend of one or multiple category...
Strategic colouring in Power BI – Part 2: Comparing a trend versus the rest
This is the second 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/ In the first post, we discussed how to use strategic colouring to compare...
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...
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...
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. [video width="728"...
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 see what the top...