cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Boudewijn Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Slicer filter another slicer

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 6
Super User
Super User

Re: Slicer filter another slicer

Hi @Boudewijn

 

Please post or share some sample data and the output expected to arrive at a solution.

 

 

Cheers

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Boudewijn Frequent Visitor
Frequent Visitor

Re: Slicer filter another slicer

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???

Community Support Team
Community Support Team

Re: Slicer filter another slicer

Hi @Boudewijn

Create a date table 

New table-> enter the following formula

Table = CALENDARAUTO()

leave no relationship between this date table and your table

4.png

 

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] )
)

3.png

 

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.

Highlighted
Community Support Team
Community Support Team

Re: Slicer filter another slicer

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

 

Boudewijn Frequent Visitor
Frequent Visitor

Re: Slicer filter another slicer

Maggie, I'm really impressed, brilliant!! It is just what the doctor ordered! Thanks for your efforts!

Boudewijn Frequent Visitor
Frequent Visitor

Re: Slicer filter another slicer

Maggie, I'm really impressed, brilliant!! It is just what the doctor ordered! Thanks for your efforts!