Button/Slicer for using different filter on a stacked bar chart

[jcolby]

Greetings,

Been stuck for a while on this, poured over the forum/google and still unsure.

I have a stacked barchart consisting of a measure(effective rate) and a column(hours) with a Company axis:

I want to add some type of button/slicer, could be a 2 option radio selection, or even just an on/off checkbox.

The button should just apply a different filter.
I only need 2 views:

When measure < 100

When measure >= 100

I've simplified the problem in an example pbix file:
https://www.dropbox.com/s/ppxt72cu29d2e6b/splitting%20effective%20rate%20example.pbix?dl=0

Greatly appreciate anyone able to have a look

[v-diye-msft · Accepted solution]

Hi @jcolby ,

Actually, you can achieve this using the filter pane:

If you'd like to use the slicer, please refer to the pbix here: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EYRoWI7UudhDvZwcfsf7D9...

(Note the measure is not blank)

Best regards,

Dina Ye

[jcolby]

Hi @v-diye-msft 

Excellent, thank you - the slicer your created is exactly what I need.

I'm missing something though.

The new table, with the desired filter selections - is there something special about creating/configuring that?
Theres no relationships and its just text?
When I add additional options or change the numbers in edit source it doesnt filter anything and breaks what you've setup, even if i just flip an operator, "<" to ">".  Or even if I change 100 to 99.

Trying to reverse engineer it, can you see what I'm missing?

- Enter Data

- Type out the desired filter options you want in a single column: "Measure < 100" "Measure >= 100"

- New Slicer visual with the filter column

- Visual filter on bar chart - Measure not blank

[jcolby]

@v-diye-msft 

ahhhhh, wasnt paying attention - didnt see the measure (i thought it was my measure lol)

Thank you!

[jcolby]

@v-diye-msft 

Tweaked your solution a bit and used a SWITCH statement

Effective Rate (Filtered) = 
SWITCH(
    SELECTEDVALUE('Filters'[ Effective Rate]),
    "< 100", CALCULATE(
        [Effective Rate #],
        FILTER(Companies,[Effective Rate #] < 100)
    ),
    ">= 100", CALCULATE(
        [Effective Rate #],
        FILTER(Companies,[Effective Rate #] >= 100)
    ),
    [Effective Rate #]
)

Thanks again, pushed my understanding wrestling with this problem