cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gaohetian8848 Frequent Visitor
Frequent Visitor

Two Customer period slicers

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

3 REPLIES 3
Community Support Team
Community Support Team

Re: Two Customer period slicers

hi, @gaohetian8848 

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 

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

Re: Two Customer period slicers

Hi Lin,

 

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

 

Thanks in advance.

 

Peter

gaohetian8848 Frequent Visitor
Frequent Visitor

Re: Two Customer period slicers

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?

 

Power BI.png

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 268 members 2,706 guests
Please welcome our newest community members: