Forum Discussion
Slicer filter another slicer
Power BI Set up;
- 1 Table
- Slicer 1 (Between) for column A (Values)
- Slicer 2 (Between) for column B (Date)
Goal:
[Count values filtered by slicer 1 and slicer 2] divided by [Count Values filtered only by slicer 2]
I have tried filters ALL, ALLSELECT and ALL EXCEPT.
I can filter with slicer 1 from 0 to 10, but it doesn't work with slicer 1 from 3 to 10.
Thanks for your effort!
Boudewijn
Hi Boudewijn
in my test,
[Count values filtered by slicer 1 and slicer 2] ---Measure
divided by
[Count Values filtered only by slicer 2] ---------Measure 2
Best Regards
Maggie
6 Replies
Hi Boudewijn
in my test,
[Count values filtered by slicer 1 and slicer 2] ---Measure
divided by
[Count Values filtered only by slicer 2] ---------Measure 2
Best Regards
Maggie
Hi Boudewijn
Please post or share some sample data and the output expected to arrive at a solution.
Cheers
CheenuSing
I found the problem;
If the slicer 2 (between) for column B (date) is formatted as date (1-1-2018 / 31-12-2018), it will not work.
If the slicer 2 (between) for column B (date) is formatted as decimal (2018 / 2018), it work's.
What to do if I want to filter on date format???
Hi Boudewijn
Create a date table
New table-> enter the following formula
Table = CALENDARAUTO()
leave no relationship between this date table and your table
Create measures
MIN = MIN('Table'[Date]) Max = MAX('Table'[Date]) Measure = CALCULATE ( COUNT ( Sheet3[index] ), FILTER ( ALLSELECTED ( Sheet3 ), [columnB] >= [MIN] && [columnB] <= [Max] ) ) Measure 2 = CALCULATE ( COUNT ( Sheet3[index] ), FILTER ( ALL ( Sheet3 ), [columnB] <= [Max] && [columnB] >= [MIN] ) )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
