Looking for correct visual

[rma1215a]

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. 

[mickey64 · Accepted solution]

For your reference.

I add 4 squeres and 1 circle shapes and use 'fx' each.

[mickey64 · Accepted solution]

For your reference.

I make a shape(PNG format) with 'INKSCAPE' and put it in front of those shapes. 

[mickey64 · Accepted solution]

For your reference.

[mickey64 · Accepted solution]

For your reference.

I add 4 squeres and 1 circle shapes and use 'fx' each.

[rma1215a]

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? 

[mickey64 · Accepted solution]

For your reference.

I make a shape(PNG format) with 'INKSCAPE' and put it in front of those shapes. 

[rma1215a]

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.

[mickey64 · Accepted solution]

Step 1: I select 2 shapes and select '差分(D)' below.

Step 2: I export that shape with 'PNG'-format.

[rma1215a]

Thank you so much!!!! I got it now and it's working. 🙂
I kept saving instead of exporting. 

[rma1215a]

Oh wow. this is really great. How did you import the shape you created in inkscape to power bi?

[mickey64 · Accepted solution]

For your reference.

[rma1215a]

Thank you so much. You've been very helpful. 

[amitchandak]

@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?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[rma1215a]

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.