cancel
Showing results for
Did you mean: Regular Visitor

## Create new chart

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 %

1 ACCEPTED SOLUTION  Microsoft

@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

4 REPLIES 4  Microsoft

@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 Regular Visitor

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  Microsoft

@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 Regular Visitor

Thank you. I really appreciate  