Forum Discussion
Visual to show the score
Team, Please help. How we can create below visual in Power BI , I have wrote the dax that give me score but i am struggling to show the score like in below graph, is there a workaround or altera...
rajulshah Thank you for your response.
Please find below two tables , Tb1 is having data of workflows created and closed , Tb2 is having the score that needs to be assigned on basis of % worflow closed, So we have a measure % Workflow closed = Divide (Worflow closed, Workflow created).
| Date | # Workflows Created | # Workflows Closed |
| Tuesday, February 1, 2022 | 118 | 77 |
| Tuesday, March 1, 2022 | 126 | 54 |
| Friday, April 1, 2022 | 109 | 56 |
| Sunday, May 1, 2022 | 110 | 81 |
| Wednesday, June 1, 2022 | 119 | 89 |
| Friday, July 1, 2022 | 126 | 87 |
| Monday, August 1, 2022 | 119 | 72 |
| Thursday, September 1, 2022 | 116 | 65 |
| % Closed | Score |
| <5% | 1 |
| 5-9 | 2 |
| 10-14 | 3 |
| 15-24 | 4 |
| 25-39 | 5 |
| 40-54 | 6 |
| 55-69 | 7 |
| 70-79 | 8 |
| 80-89 | 9 |
| 90-100 | 10 |
Thank you for your support 😊
rajulshah
Resident Rockstar
Resident RockstarAnonymous ,
Do you want something like below with conditional formatting? Please confirm.
rajulshah Thank you for your response.
I want something like below graph, where depending on the % of metric, as in this case % of workflow closed, we will assign a score, and score needs to be shown like in below graph.
Thank you 😊