cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Gauge target on different granularities

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

3 REPLIES 3
Super User IV
Super User IV

Re: Gauge target on different granularities

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Community Support
Community Support

Re: Gauge target on different granularities

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.

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
Not applicable

Re: Gauge target on different granularities

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors