Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rma1215a
Frequent Visitor

Looking for correct visual

Hi everyone, I just would like to ask for your suggestions regarding this. So we have a project whose mock up is below. 

 

rma1215a_2-1695007504927.png

 

 

4 ACCEPTED SOLUTIONS
mickey64
Responsive Resident
Responsive Resident

For your reference.

 

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

mickey64_0-1695016140671.png

 

View solution in original post

mickey64
Responsive Resident
Responsive Resident

For your reference.

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

mickey64_1-1695286707361.png

 

mickey64_0-1695286670797.png

 

View solution in original post

mickey64
Responsive Resident
Responsive Resident

For your reference.

mickey64_0-1695287743499.png

mickey64_1-1695287808792.png

 

View solution in original post

mickey64
Responsive Resident
Responsive Resident

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

mickey64_0-1695360070859.png

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

mickey64_1-1695360258185.png

mickey64_2-1695360344428.png

 

View solution in original post

11 REPLIES 11
mickey64
Responsive Resident
Responsive Resident

For your reference.

 

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

mickey64_0-1695016140671.png

 

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
Responsive Resident
Responsive Resident

For your reference.

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

mickey64_1-1695286707361.png

 

mickey64_0-1695286670797.png

 

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
Responsive Resident
Responsive Resident

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

mickey64_0-1695360070859.png

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

mickey64_1-1695360258185.png

mickey64_2-1695360344428.png

 

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

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

mickey64
Responsive Resident
Responsive Resident

For your reference.

mickey64_0-1695287743499.png

mickey64_1-1695287808792.png

 

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

amitchandak
Super User
Super User

@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...

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. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.