drill down when value is 0

[visuals101]

This may be something simple I'm missing but let's say for example I have number of sales arranged by country and when I drill down it is sales by city. However there is one country that that has 0 sales in the country and I want to drill down to see which cities we are currently selling in which are 0. Also these values are linked to another table where it shows the salesperson for each city so when I click on the value for the listed city it highlights the value for the given salesperson. I currently can't figure out how to drill down when the value is 0.

[Anonymous]

Hi @visuals101,

It will be help if you share some detail contents. for instance: sample data, screenshots, table structure.

BTW, If your data not contains hierarchy relationship and mapping, I don't think power bi visuals will auto analysis your sales data to drill down level.

Regards,

Xiaoxin Sheng

[visuals101]

Let's say for example we are modeling results on number of sales per country. When you drill down on the country you can see the number of sales per city. However, you want to drill down on the countries that have 0 sales to see what cities are listed as zero in that country. There is also a relationship to another table where it will highlight the salesperson for that city. Since the value is 0 sales I can not drill down on the country to see the cities and also I can not click on the name of the country to have it highlight the sales person in another table. Any ideas?