Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Link date filters

I want to link two filters within the same page. What I want to do is the following: I have a filter that marks "last 3 months", "last 6 months", "last year" and another filter that marks a range of...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Syndicate_Admin , while you can achieve this using a date and slicer with these values.

https://community.powerbi.com/t5/Desktop/Required-custom-date-Slicer-Last-7-days-last-15-days-last-30/m-p/1284966#M561629

or Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

 

But you display date range in card not in another slicer 

 

 

if you want to compare two periods

How to use two Date/Period slicers:https://www.youtube.com/watch?v=WSeZr_-MiTg

 

 

What you need is very similar to measure slicer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern