Forum Discussion
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...
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
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
Thank you. I really appreciate