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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gmeyers
Regular Visitor

Display multiple details on stacked column or bar chart

Similar to show all details on a pie chart, I'm trying to determine if there is a way to do something similar to show all or selected values on a stacked column or bar chart similar to the below example which shows both a count and a percentage. 

 

Stacked_Col_example.jpg

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@gmeyers,

It is not possible to show the chart as you described.

A workaround is drag the percentage column to Tooltips of Stacked column chart. Assume that you have the following table, you can create the percent measure in your table.

percent = CALCULATE(SUM(Table[Value]))/CALCULATE(SUM(Table[Value]),ALLEXCEPT(Table,Table[Date]))

1.JPG

2.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@gmeyers,

It is not possible to show the chart as you described.

A workaround is drag the percentage column to Tooltips of Stacked column chart. Assume that you have the following table, you can create the percent measure in your table.

percent = CALCULATE(SUM(Table[Value]))/CALCULATE(SUM(Table[Value]),ALLEXCEPT(Table,Table[Date]))

1.JPG

2.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

As there is no current functionality, I will submit as an idea for future enhancement.

Hi Lydia,

 

Thanks for taking the time to respond.  Unfortunately, your workaround does not satisfy the need as the goal is to have something that can ultimately be used in a PowerPoint presentation.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.