Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a visual like below with % of grand total image 1. However, I would like to have % calculation by column total not by grand total. I tried few solutions suggested by the community, however it ended up with 100% stacked column like second image. In Tableau is out of the box and we get the desired result in couple of clicks.
Please help me with the DAX forumula. thank you.
Image 1
Image 2
Desired Outcome
Solved! Go to Solution.
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
I couldnt get how to do this. could you please simplify it? in this example ListPrice is repeated as column name and VAR name as well.
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
Thank 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
Thank you. I will go with tooltip since no other workaround. PBI should improve the visuals like Tableau.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |