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