cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kundan76
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.

Capture.PNG

 

 

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

@kundan76

 

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

Create new chart_1.JPG

 

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.

Create new chart_2.JPG

 

Best Regards,

Herbert

View solution in original post

4 REPLIES 4
v-haibl-msft
Microsoft
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%

 

Create new chart_1.jpg

 

Best Regards,

Herbert

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

 

@kundan76

 

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

Create new chart_1.JPG

 

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.

Create new chart_2.JPG

 

Best Regards,

Herbert

View solution in original post

Thank you. I really appreciate

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!