Technique to display the charts for 3 mnths gym interval

[Anonymous]

Hi

I have some N no of bi sheets as I created using drag nd drop by columns. They display the data for a particular month based on slicer selection.

Is there any way that I can show those charts for 3 months or 6mnths interval based on slicer selection.

 

[negi007]

@Anonymous  The easiest way of doing it would be using bookmarkts. You can have 3 different type of bookmarkts linking to 3 months, 6 months or any other. On your dashboard, create 3 rectangle boxes and linked each to each type of bookmark. On selection, your dashboard view will change as per your requirements. Let me know if it helps you.

[v-stephen-msft]

Hi @Anonymous ,

You may create a seperate table as follows.

Month interval

Three-month interval

Six-month interval

Create a measure, use the slicer to select monthly intervals to display different results.

There is a similar post which you can refer:

https://community.powerbi.com/t5/Desktop/Count-Users-and-Company-Between-this-value/td-p/1335870

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , if you want to show the trend, refer this way

https://www.youtube.com/watch?v=duMSovyosXE

if want rolling three or six month data try with a date table

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-3,MONTH))
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX(Sales[Sales Date]),-3,MONTH))
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.