Visual to show the score

[Anonymous]

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 alterantive to this.

Thank You 😊

Cheers

[rajulshah]

@Anonymous ,

Can you please share sample data file so that I can work on it?

[Anonymous]

@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]

@Anonymous ,

Do you want something like below with conditional formatting? Please confirm.

[Anonymous]

@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 😊

[rajulshah]

@Anonymous ,

I am afraid, we cannot achieve the exact same visual.

[Anonymous]

@rajulshah No Problem , Thank you for your time and support.