Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

Thank You 😊

Cheers

Need Help

6 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Anonymous ,

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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 😊

      • rajulshah's avatar
        rajulshah
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        Anonymous ,

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