Forum Discussion
Helper IButton/Slicer for using different filter on a stacked bar chart
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
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/EYRoWI7UudhDvZwcfsf7D9UB5cs05lGxaJsCNFXjML6sMw?e=0A4FjB
(Note the measure is not blank)
Best regards,
Dina Ye
4 Replies
- v-diye-msft
Community Support
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/EYRoWI7UudhDvZwcfsf7D9UB5cs05lGxaJsCNFXjML6sMw?e=0A4FjB
(Note the measure is not blank)
Best regards,
Dina Ye
jcolbyHi 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
ahhhhh, wasnt paying attention - didnt see the measure (i thought it was my measure lol)
Thank you!