Chiclet slicer not working on bar chart

[Anonymous]

I have created a chiclet slicer and want the bar chart to display either 'Factory1Gas' or 'Factory2Gas'  only when each of the buttons is clicked. ie when I click on Factory1Gas, the bar chat for 'Factory1Gas'  to display and vice versa. But it doesnt seems to work. If I click 'Factory1Gas', it is still displays bar chart and calculation for 'Factory2Gas'..Is there anything else I can do. Is there a better visualisation or chart , measure, column, etc to achieve this?? Is there any thing missing in my relationship? Which is a better approach or visual to use so it will /..Please help

[v-sihou-msft · Accepted solution]

@Anonymous

Generally, you need a Measure table populating the Slicer, then you need to create one selected_measure for each selection from the slicer to SWITCH corresponding measure. For more details, please refer to articles below:

Dynamic Measure Selection in Power BI

Dynamically select measures to be shown on a Power BI visual via slicer

Regards,

[tjd]

Take a look at the You Tube video, "Change Measures Using A Slicer" which shows you how to do this.