Brisbane, 4000 QLD

+61 4 3836 7017

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...

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....

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 below DateInNumberFormat = VALUE (...