Hi everyone, I just would like to ask for your suggestions regarding this. So we have a project whose mock up is below.
Initially, we thought that we could use a pie chart with this. The context is that each Criteria has their own specific measurements. For example, for Criteria A, Score X should be equal to 0 for it to be green, if not it will be either yellow or red. Same goes with the rest. So their colors would depend on the scores but the scores are different from each criteria. Let's say for Criteria B, Score Y has something to do with percentage, unlike the Score X of Criteria A. For it to be green, Score Y has to be 100%, otherwise, it will be a different color.
Right now we're not really sure if a pie or a donut chart will do since for this, there should only be one source of value. Or even if power bi is the best tool to be used. Any inputs will be very helpful. Thank you so much.
Solved! Go to Solution.
Thank you @mickey64 . I was actually thinking about this. The one challenge I am still trying to figure out is that I need a quadrant shape. PBI has limited shapes. would you happen to know if there is a possibility to import a shape?
Hi @mickey64, So what I did is I made a square then put a circle on top of it. I chose Path, then Exclusion and saved it as png. but it did not make the whole in the middle transparent.
@rma1215a , You can use donut and card visual in middle with image behind
For conditional formatting the workaround is, to do it on the bar and convert it to donut.
How to do conditional formatting by measure and apply it on pie?
Thank you, Amit. Great, I actually watched your video already and it was really helpful. We did try a donut chart as well. The one challenge that we are experiencing right now is the color coding. If we use the conditional formatting, it just accepts one rule or measurement. like for each part of the donut, there is a specific rule that we need to use.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.