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, i'm quite new to Power BI, i manage to make some pages with several Matrix and slicers.
The thing is that now i want to filter on the whole page in the Slicer butreferencing another column.
For ex.
Date |Product|Price|Type
01-04-2018 |a | 10 | Z
01-01-2019 |b |11 | X
01-03-2017 |c |13 | Z
01-01-2018 |a |12 | Z
01-05-2017 |d |15 | X
The type Column is not displayed on the report.
I want to make a Slicer based on the Date that if i choose >=01-01-2019 it filter to show only X type.
If i choose < 01-01-2019 it shows only Z type.
Is there a way to achieve this?
I hope my explanation is clear.
Thank you very much!
Solved! Go to Solution.
Hi @marcos_osorio,
Please check the following steps as below.
1. Create a date table. Then create relationship between it and the fact table.
DATE = CALENDARAUTO()
2. Create a measure as below and make the table visual filtered by the measure.
Measure = var _maxdate = MAX('DATE'[Date]) var _mindate = MIN('DATE'[Date]) var _type = MAX(Table1[type]) return IF(_maxdate<=DATE(2019,01,01) && _type="Z",1,IF(_mindate>=DATE(2019,01,01) && _type="X",1,0))
For more details, please check the pbix as attached.
Regards,
Frank
Hi @marcos_osorio,
Please check the following steps as below.
1. Create a date table. Then create relationship between it and the fact table.
DATE = CALENDARAUTO()
2. Create a measure as below and make the table visual filtered by the measure.
Measure = var _maxdate = MAX('DATE'[Date]) var _mindate = MIN('DATE'[Date]) var _type = MAX(Table1[type]) return IF(_maxdate<=DATE(2019,01,01) && _type="Z",1,IF(_mindate>=DATE(2019,01,01) && _type="X",1,0))
For more details, please check the pbix as attached.
Regards,
Frank
Thank you very much, this is what i wanted.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |