Single select filter / forcing users to see only item at a time

[hoosha_11]

Hello,

I have a bar chart, and due to the large amount of data, I want to limit users to selecting only one city at a time. When they open the report, they should see only one city, but they should still be able to select any other city—one at a time. I tried using a single-select slicer, but it doesn’t work properly. For example, if I select AccountId = 1, it filters to a single city (e.g., New York). But, when I switch to AccountId = 2, and this account does not have New York as a city, the chart appears blank.

Any idea is appreciated! 

[Idrissshatila]

Hello @hoosha_11 ,

in the measure that shows the value, you can replace blank with zeros thus when they select account two in your scenario, it will still show newyork as zero.

[hoosha_11]

Thanks, but each account has different cities. By default, 'Account' is not filtered, so when I use a single-select slicer, Power BI randomly selects a city. When the account changes, if the new account does not have the previously selected city, the chart will be blank.