Brisbane, 4000 QLD

+61 4 3836 7017


Visualising ratings data in Power BI

The inspiration for this article comes from the app Webull which is a stock market app for investors which includes real time quotes, financial news, investing advice etc. It is one of the best apps in the market if you are a frequent investor in the stock market. It is ...
Read More

Control charts in Power BI

The statistical control chart is a graph used to analyse changes of a process over time. The variable to be analysed is plotted against the y-axis and time is plotted against the x-axis. Some of the features of a control chart is the presence of an average line, and lines ...
Read More
/ Control charts, DAX, Power BI, Power BI

Time intelligence deciphered

Do you get confused between various time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR, PARALLELPERIOD etc. Well, I just have the perfect dashboard for you to understand all those functions. This dashboard has been designed using the Adventureworks dataset. Move the Period slicer to see what happens to the various measures.Link here ...
Read More
/ DAX, Power BI, Power BI, Time Intelligence

Visual level filters for slicers in Power BI

Visual level filters for slicers is one of the most requested features in Power BI.There is no capability yet for filtering slicers in Power BI but there is a work around which I will demonstrate here and it doesn't involve any DAX ! I'm using the Adventure works data set ...
Read More
/ Power BI, Power BI, Slicers

Dynamic vertical/ Y axis line in Power BI

In this post I will showcase how to set up dynamic vertical line in Power BI and use it to explore your dataset.The Adventure dataset is used in this example. In the Calendar table create a new column called DateInNumberFormat as belowDateInNumberFormat = VALUE ( dimCalendar[DateID] )We will also create ...
Read More

Using parameters to colour code Power BI pages

In this blog post I will discuss how to create a Power BI template for your organisation with colour coding for different departments. Say you want to create standard reporting template for your organisation. You have already created a custom Power BI theme with your company colours, font, layout etc ...
Read More
/ Parameters, Power BI, Power BI, Template