August 29, 2019

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

We will also create a Summary Orde...

April 25, 2019

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 workaround which I will demonstrate here and it doesn't involve any DAX !

I'm using the Adventureworks dataset...

March 12, 2019

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

February 24, 2019

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

September 8, 2018

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

January 19, 2018

 Image courtesy

You say the hill's too steep to climb


You say you'd like to see me try


You pick the place and I'll choose the time

And I'll climb

The hill in my own way

~ Fearless/Pink Floyd

When I started learnin...

January 24, 2017

" I'll need some information first, just the basic facts" - Comfortably Numb

We hear the terms data and information a lot in our lives. What do they mean ? Are they the same ? If not what is the difference between them ? I break it down in this article with an example


Please reload