Forum Discussion
Advocate IIIStacked Column - Percentage by Column Total
Hi jack555 ,
Base on my research, there is no option or feature to make the stacked column chart display the percentage values while the Y axis display normal value range... As a workaroud, you can put the measure which get the percentage onto Tooltips field, the percentage values will display in tooltips just as below screenshot... Please find the details in the attachment....
In addition, you can submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards
Hi jack555 ,
I created a sample pbix file(see the attachment), please check if that is what you want. You can create a measure as below to get it:
Measure =
VAR _team =
SELECTEDVALUE ( 'Table'[Team] )
VAR _part =
SUM ( 'Table'[GT Count] )
VAR _perteam =
CALCULATE (
SUM ( 'Table'[GT Count] ),
FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Team] = _team )
)
RETURN
DIVIDE ( _part, _perteam )
If the above one can't help you get the desired result, please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Advocate IIIThank you for sharing a soultion with real example. However this results in 100% stacked column. But I would like to have the regular stacked column (not 100%) with the labels % totaling to 100 without affecting the height of column. Below is the desired outcome.
Hi jack555 ,
Base on my research, there is no option or feature to make the stacked column chart display the percentage values while the Y axis display normal value range... As a workaroud, you can put the measure which get the percentage onto Tooltips field, the percentage values will display in tooltips just as below screenshot... Please find the details in the attachment....
In addition, you can submit a new idea. It is a place for customers provide feedback about Microsoft Office products . What's more, if feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best Regards
- jack555
Thank you. I will go with tooltip since no other workaround. PBI should improve the visuals like Tableau.