Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I am working on report where the first page is a summary page and is driven by a basic date selection. Elsewhere in the report I am showing trends. I would like for the selected date from the summary page to be the basis for the relative date on the trends page.
For Example
Summary page slicer selection = 7/31/2021 to drive trends page data to be <=7/31/2021
What is the best way to accomplish this? ideally, I would like the user to only have to filter in one place.
Thanks in advance for any help.
Solved! Go to Solution.
Hi @Esef ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Slice date =
CALENDARAUTO()
2. Use the [date] column of the Slice date table as the slicer in Page1 and Page2 respectively.
3. Select Sync slicers in View, so you can select the slicer of Page1, which will be synchronized to the slicer of Page.
4. Create measure.
Flag =
var _select=SELECTEDVALUE('Slice date'[date])
return
IF(MAX('Table'[date])<_select,1,0)
5. Place Measure[Flag] in the Filter in Page2, set is=1, and apply filter.
6. Result.
Select 2021.7.31 in Page1, and display data less than 201.7.31 in Page2.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Esef ,
I created some data:
Here are the steps you can follow:
1. Create calculated table.
Slice date =
CALENDARAUTO()
2. Use the [date] column of the Slice date table as the slicer in Page1 and Page2 respectively.
3. Select Sync slicers in View, so you can select the slicer of Page1, which will be synchronized to the slicer of Page.
4. Create measure.
Flag =
var _select=SELECTEDVALUE('Slice date'[date])
return
IF(MAX('Table'[date])<_select,1,0)
5. Place Measure[Flag] in the Filter in Page2, set is=1, and apply filter.
6. Result.
Select 2021.7.31 in Page1, and display data less than 201.7.31 in Page2.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |