Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I am looking for a solution here. Basically I want to filter(A) one date slicer based on maximum date selected in another date slicer(B).
Let's say If I am selecting any particular date in slicer B then other slicer A should show only previous 7 days of selected date from slicer B.
Anothe example is like I am selecting 20th April in slicer B then slicer A should show only 7 days date range like (12th april to 19th April only)
Hi @Anonymous ,
It is not yet possible to use slicers to dynamically control other slicers. Calculated columns and tables are not recalculated when the slicer changes. In other words, the slicer does not interact with the calculated table and calculated columns, and no filtering is possible.
Someone has proposed a similar idea and you can vote for this idea.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems with it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi JirkaZ, Thanks for replying.
I need the slicer A to show minus 7 days only from maximum selected date from slicer B.
I am not sure what should be the desired dates here because it totaly depends on the selection of date from slicer B. I just need to see (-7 days) of that selected date.
The desired dates will result from a calculation within the measure... example would be to use
DATEADD(DimDate[Date], [MaxDateFromSlicerB], -7, DAY)
It looks like I would need two date table instead of one for each slicer. Correct me if I am wrong.
Yup - the one for slicer B wil be disconnectet from the rest of the data model
Hi JirkaZ,
I am using below dax however it is throwing some error.
Create a measure that will hold the desired dates and that will return 1 or 0 based on the date check. Filter Slicer A by that measure where the value = 1.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |