Two Customer period slicers

[Anonymous]

Dear All,

How Do I create two slicers for a report but i can customised each slicer (period) whatever I like?say i have current period and previous period and I can adjust the length of the current and previous period whatever I like (they can be different time in length).

I tried the below but it did not work properly as my two slicers can only adjust the current period data not the previous period data.

https://www.sqlbi.com/articles/filtering-and-comparing-different-time-periods-with-power-bi/

thanks,

Peter

[v-lili6-msft]

hi, @Anonymous 

I also had tried as the article before, and it works well, there should be something wrong in other.

could you share your sample pbix file and expected output for us have a test?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin 

[Anonymous]

Hi Lin,

I solved this out. However, I do not understand why in the manager relationships, we need to untick the active button between "Previous Date (Date)" and "Date (Date)". 

Is it becasue we use the formular "

     USERELATIONSHIP( 'Date'[Date], 'Previous Date'[Date] )"

Sorry I am not sure about the details about its logic.  Please explain if posisble. Also it seems we cannot attach excel file in the post?

[Anonymous]

Hi Lin,

Sorry how Do I upload the files as I cannot see an attachment function?

Thanks in advance.

Peter