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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors