Create new chart

[kundan76]

Hello,

Based on the following values

I have following colum in my task list

Priority

Factor

Max Score

Actual Score

Where should we be?

Based on these column I created chart in excel  attached.

Budget (Where should we be%) 35%
Remaining 65% Where we are? 33%
pointer 0.005
end 1.66
Max 100%
Budget 200%

I need to create same in Power BI. I need to add all the values in Priority
Factor
Max Score
Actual Score
Where should we be? and get the %

[v-haibl-msft]

@kundan76

I’m not quite clear about following items you mentioned. According to your chart in excel, I think you can try with the Gauge visual.

pointer 0.005

end 1.66

Max 100%

Budget 200%

Best Regards,

Herbert

[kundan76]

Hello Herbert,

Here are my calculation

Where we should be =  In Percent (Sum of Where we should be /Sum of Max Score )

Remining = 100% - Where we should be

Where we are = In Percent (Sum of Where we are/Sum of Max score

Can you please guide me to create guage . What should I use in value like sum or average or maximum and where

Thanks for your help

[v-haibl-msft · Accepted solution]

@kundan76

You can create some measures as below to get the percent results. For example, we have a table like below.

We need to change the format of these measures to “Percentage”.

Percent_Where we should be = SUM( Sheet1[Where we should be] ) / SUM( Sheet1[Max Score] )

Percent_Where we are = SUM( Sheet1[Where we are] ) / SUM( Sheet1[Max Score] )

Percent_Max = SUM( Sheet1[Max Score] ) / SUM( Sheet1[Max Score] )

I’ve also uploaded my .pbix file here for reference.

Best Regards,

Herbert

[kundan76]

Thank you. I really appreciate