Forum Discussion
Helper IIICompare other values with selected slicer values
Hi I have hirarchial slicer(Country, Market, Branch & Zone) along with year and month slicer.
From above slicer if i select one year and one month and one country then the bar chart should show values for remaining countrys
ex 1: Year-2025 , month -1 , country- UK , then the bar for country - US should also displayed.
ex 2: Year-2025 , month -1 , country- UK,Market - MN , then the bar values for country - UK (with in the selected country)should also displayed for all remaining Markets.
Same with Branch and zone.
Here is my sample data
and sample graph
Thanks in advance.
- Why do you have a location hierarchy but not a time hierarchy?
- elements of a hierarchy ideally should not have duplicates ("children with multiple parents")
- you should use proper dimension tables for the calendar and the locations. For this execise I left your format intact but I would strongly recommend you refactor this.
ex 1: Year-2025 , month -1 , country- UK , then the bar for country - US should also displayed.Don't select a country.
Year-2025 , month -1 , country- UK,Market - MN , then the bar values for country - UK (with in the selected country)should also displayed for all remaining Markets.Select a country but don't select a market.
Selecting one item and then expecting to see the item and all other items will lead to user confusion. At a minimum you will want to color code them differently.
6 Replies
- lbendlin
Super User
You will need to use disconnected tables to feed each slicer. Then use a measure to control row visibility in the main visual.
User232431Thank you , actually i am new to Powerbi , if i have sample .pbix file then it would be helpful.Thanks
- lbendlin
It's the other way around. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523