Forum Discussion

CharlotteMoj89's avatar
CharlotteMoj89
New Member
11 months ago
Solved

Building a Circle visual (not a KPI one) with colour conditional formatting

Hi there, 

I have been asked to create a visual that is essentially a green circle (hollow with green outline) with the data visible in the middle. The only one I can find on my powerbi is the Paypal KPI Donut Chart but the problem with this is, I need the green outline to be just a full circle not matter what the figure is whereas this visual only fills the green colour in for whatever % the figure is. 
I've also considered adding a circle from the shapes option but this is a fully coloured circle, not a hollow one with an outline. 

Is there anyway I can do this or anyone that can help? I have tried also this visualGitHub - blackleadsu/powerbi-visuals-react-circleCard: A simple PowerBI Custom Visual made with React but there isn't a pbiviz file for me to download and upload (but I think this is black anyway) and i can't build me own with the limitations on work laptop. 

Any help would be greatly appreciated 🙂 

Need Help
  • GrowthNatives's avatar
    GrowthNatives
    11 months ago

    In that case you can try this alternative method :

    1. Create new measure 'Full Circle Measure'

    DAX 
Full Circle = 1


    2. Add a Donut chart visual to your report canvas & Drag your new Full Circle measure into the Values field of the donut chart. It will now display a solid, complete circle.

    3.  Slices: Change the color to the shade of green you want.

    Spacing: Adjust the Inner radius to create the hollow circle effect. A value around 80-90% works well.

    Turn off unnecessary elements: Disable the Title, Legend, and Detail labels as you won't need them.

    4. Insert a Card KPI in the centre of donut 

    Format the Card:

    Turn off the Category label.

    Adjust the font size and color of the Callout value.

    Under General -> Effects, turn the Background off to make it transparent.



     

7 Replies

  • GrowthNatives's avatar
    GrowthNatives
    Icon for Super User rankSuper User
    11 months ago

    Hi CharlotteMoj89 ,
    You can follow these steps to create the same shape :

    • Insert a Shape → Donut (not circle).

    • Format it:

      • Set fill = none

      • Set outline = green

      • Adjust thickness so it looks like a hollow circle.

    • Add a Card visual on top → place your KPI value inside the circle.

    • Group them so they move together.


    ⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
    💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
    🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

     

    • CharlotteMoj89's avatar
      CharlotteMoj89
      New Member
      11 months ago

      Hi, 

       

      Thank you so much for getting in touch. 
      I don't seem to have the option of a donut unfortunately (from either the drop down or in the format shape section) Below is a screen grab of my options:

      Thank you!

      Charlotte 

      • GrowthNatives's avatar
        GrowthNatives
        Icon for Super User rankSuper User
        11 months ago

        In that case you can try this alternative method :

        1. Create new measure 'Full Circle Measure'

        DAX 
Full Circle = 1


        2. Add a Donut chart visual to your report canvas & Drag your new Full Circle measure into the Values field of the donut chart. It will now display a solid, complete circle.

        3.  Slices: Change the color to the shade of green you want.

        Spacing: Adjust the Inner radius to create the hollow circle effect. A value around 80-90% works well.

        Turn off unnecessary elements: Disable the Title, Legend, and Detail labels as you won't need them.

        4. Insert a Card KPI in the centre of donut 

        Format the Card:

        Turn off the Category label.

        Adjust the font size and color of the Callout value.

        Under General -> Effects, turn the Background off to make it transparent.



         

    • CharlotteMoj89's avatar
      CharlotteMoj89
      New Member
      11 months ago

      Hi Praful_Potphode 

      Thanks for your message 🙂 

      Yes I did try one of these - the only issue is, my boss would like the figures to sit within a green circle no matter what the % is. With this visual I found that if the % of stock going off (as an example) was 15%, then only 15% of the visual was highlighted in green, which makes the visual look like a bad/under performing metric, whereas actually, for this particular one - the lower % of stock going off the better! 

      Ideally, she wanted the visual to be Green if it was on or above target and red for any that were falling under target - which I thought I had cracked with the Circle KPI Gauge (the first 2 I tried were at 99ish %) but then when I did the same for the metric for which 'lower is better', the gauge looked like this:

      So I think based on my (lack of) ability in powerbi, I may have to manage expectations of my boss of not having conditional formatting on the circle and just sticking with the fix sent by GrowthNatives  - unless there are any other ways anyone can think off 🙂 

      Thanks