Wednesday 20 July 2016

Identifying Record Breaking Months.

In a bar chart time series of year and month,highlight each bar every time when a new max is reached in the sales as below.


Solution:-

Step 1:-
Create Calculation that finds each new maximum starting from the first value. Then check to see if that value equals the current Sales value. 


Step2:-

Drag the new calculation to the colors shelf. It Highlights record breaking months in orange and remaining in blue.



Thanks Guru's,
Prazval.ks







DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks