Forum Discussion
Building a Circle visual (not a KPI one) with colour conditional formatting
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 donutFormat 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.
Super UserHi 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]
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
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 donutFormat 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.
Fabulous! Thank you so much, this is just what I need 🙂
And thank you for explaining in lay mans for a newbie!
