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
Elios
Regular Visitor

Stacked graphs with counts and percentages

I have 2 items: Completion rate (in %) and Count of statuses

 

Statuses have only 2 values: Complete or Incomplete

 

I want to have a graph, that shows me the completion rate for each bar and the number of complete and incomplete items

 

It would look like as in the following excel file: 

Model picture.png

How to obtain such a graph on PBI ?

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Elios ,

 

According to your description, currently, for the latest version of powerbi desktop, there is no such visual satisfaction. My suggestion is to create a tooltip to achieve a similar effect, can display the specific value distribution in each histogram. The reference is as follows:

 

vhenrykmstf_0-1624437259352.png

 

The specific creation steps can refer to the following blog link: Power BI Tooltip | How to Create and Use Customize Tooltips in Power BI? (wallstreetmojo.com)


Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @Elios ,

 

According to your description, currently, for the latest version of powerbi desktop, there is no such visual satisfaction. My suggestion is to create a tooltip to achieve a similar effect, can display the specific value distribution in each histogram. The reference is as follows:

 

vhenrykmstf_0-1624437259352.png

 

The specific creation steps can refer to the following blog link: Power BI Tooltip | How to Create and Use Customize Tooltips in Power BI? (wallstreetmojo.com)


Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Elios , I doubt you can show both togther, But using calculation group you should be able to switch. check

https://www.youtube.com/watch?v=UnG0u8J0pSc

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.