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

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

 

Highlighted
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!