Gauge in relation with other data

[Anonymous]

Morning guys,

i want to create a gauge that show me the percentage of a value filtered from a series of it and i would like to link the color of the gage to the color used in another chart for the same value.

So it's a series of folder with their respective sizes. I want the gauge to show the percentage of a specific folder over the total (which is a different measure

1 : Initial visual where the folder color is set (Yellow for 09_WORK)

2 : Gauge filtered with the 09_WORK value

3 : Total size to use as the maximum value in the gauge

4 : Display a percentage

T

Thanks for any help

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on test, you could refer to below measures:

Total size2 = SUM('Folder Size Data'[Size])

Percentage = CALCULATE(SUM('Folder Size Data'[Size]),FILTER('Folder Size Data','Folder Size Data'[Folder]="09_WORK"))/[Total size2]

Result:

You could also download the pbix file to have a view.

Regards,

Daniel He

[Anonymous]

This looks awesome Daniel 🙂
I'm trying to replicate, to make sure i understand but ...

I created a new measure

CalcTotalSize = SUM('Folder Data'[Size])

I used Calc to know i'm using it on a different measure as a calculated measure

Then i created this one

WorkPercentage = CALCULATE(SUM('Folder Data'[Size]),FILTER('Folder Data','Folder Data'[Folder]="09_WORK"))/[CalcTotalSize]

The data source name is slightly differnet in the one im trying to replicate

So i started a new Gauge and added the WorkPercentage measure as the Value.

Then added the CalcTotalSize measure as the Maximum value and set it to show as Percent of grand total.

Sounded about right to me but ... this is what i get. What am i missing?

Dataset is here: https://www.dropbox.com/s/b73x9i9cagn0of3/Chart%20Visuals%20Sample%20V2.pbix?dl=0

[Anonymous]

Good morning again 🙂 I think i got the formula right but i can't get the value to display as a % When i place your value in a Card i get a percentage directly. When i place my value in one i still get a number. Any idea why?

[Anonymous]

Ok, i found what i was missing 🙂 I needed to change the Format under Modelling | Formatting to show percentage tahnks for your help

[Anonymous]

Here's a link to the pbix, sorry about that

https://www.dropbox.com/s/d5rvc9xzu22l5s7/Project%20Management%20Sample%20Dashboard.pbix?dl=0