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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

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'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