Data and calculations changing according to date slicer

[Anonymous]

Hi dear community, 

I have the following situation:

A realtive date slicer is added to my report. As you know it currently has following options:

• days
• weeks
• months
• years

The goal is to  get a measure and respective vizualization where I can see the comparison between the period from slicer and exact prior period for the slicer choice. 

For example

• if in the slicer I have last week, I will get the value for last week vs prior week.
• if in the slicer I have last month, I will get the value for last month vs prior month, etc. 

In short it is about dynamicaly calculated measure which will understand the logic of the slicer and update accordingly. I know and I have created measures like:

PW New Sessions = CALCULATE([new],DATEADD('Calendar'[Date],-7, DAY)) which works only with weeks.

PM New Sessions = CALCULATE([new],DATEADD('Calendar'[Date],-1, Month)) which works only with month.

The idea and desired measure is a combination of those where the calculation logic is connected with slicer. 

I have seen this thread, but the link is not working more. @v-shex-msft

https://community.powerbi.com/t5/Desktop/Calculated-Column-Table-Change-Dynamically-According-to-Sli...

Will be grateful for any advice/information you can share with me.

Cheers, 

Saro

[Anonymous · Accepted solution]

@Anonymous 
Currently, Power bi does not support filtering based on the selected period in Relative fitler. The linked post is not really relevant to your case.

As a workaround solution, I would recommend you to create a measure for each time period, and then filter the measures to be displayed on the visual by creating a slicer table. Please see my pbix sample, remember you need to select the period in both slicers.

https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/Ecji-DpgpJ9Kif0TF-8byi0B27FIgwonWpZBY7Pyku6UaA?e=AMlvkS

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you so much!

[amitchandak]

@Anonymous , for slicer, refer :

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

For week refer

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123