Forum Discussion

kundan76's avatar
kundan76
Regular Visitor
9 years ago
Solved

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  at...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    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's avatar
kundan76
Regular Visitor
9 years ago

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's avatar
v-haibl-msft
Microsoft Employee
9 years ago

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's avatar
    kundan76
    Regular Visitor
    9 years ago

    Thank you. I really appreciate