Gauge target on different granularities

[Anonymous]

Hello everyone, 

My problem is the following : I have a measure that I presented in a radial gauge on my report, and for this measure I have targets on the Global level, then on the country level, and again at the industry level (different from a country to another). 

I have different slicers on my report /country and /industry, so far I managed to set the targets on the industry level, so when I choose a country and an industry the target is showing correctly, but I can't figure out how to set it so when I only select a country (and all industries) the global target show up, and same thing when I don't filter anything I would like the global target to show up.

Is there a way (surely throught a DAX expression ?) to make it happen ? 

Thanks for your help,

Alexandre

[v-lid-msft]

Hi @Nathaniel_C ,

I am sorry that I cannot understand your requirement, Could you please provide more details about it? Kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lid-msft ,

Unfortunately the data I work with is confidential, I managed to recreate a sample data with generic values 

Here is the link : https://kedgebs-my.sharepoint.com/:f:/p/alexandre_grau/EsuhKBBk4OxLjpa-FQlBbUsBejyDFR5b2dbVNTz2a8pv4...

A few informations : On the target sheet, I added the global targets fyi, but I cannot put it that way because the Function "target global" doesn't match with anything in my data table, thus I won't have any data showing in the gauge.

What I want to achieve is that when my slicers are in "Select all" position, the global target show up on the gauge target (for country if only the country slicers is filtering, and the global target for Europe when both slicers are on select all)

Please keep in mind that the rest of my dashboard is also linked to these slicers

Thanks for you help, don't hesitate if you need more info

Alexandre

[Nathaniel_C]

Hi @Anonymous ,

please kindly read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, can you give us more info? It might be in the relationships of your tables?

Nathaniel