Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Dev_19
Frequent Visitor

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

 

Dev_19_0-1677230213608.png

Thank You 😊

Cheers

6 REPLIES 6
rajulshah
Super User
Super User

@Dev_19 ,

 

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

@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, 202211877
Tuesday, March 1, 202212654
Friday, April 1, 202210956
Sunday, May 1, 202211081
Wednesday, June 1, 202211989
Friday, July 1, 202212687
Monday, August 1, 202211972
Thursday, September 1, 202211665

 

 

% ClosedScore
<5%1
5-92
10-143
15-244
25-395
40-546
55-697
70-798
80-899
90-10010

 

Thank you for your support 😊

@Dev_19 ,

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

rajulshah_0-1677481316939.png

 

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

 

Dev_19_0-1677483196318.png

 

Thank you 😊

 

@Dev_19 ,

 

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

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.