Power BI- When Total Label on Stacked visual is not sufficient
Problem: When the total label in stacked visual does not do the desired job, what is the alternate
Solution: Power BI has provided total label under stacked visual sometime back. and you can show the total label using the visual property
But if you use avg or percent measure, it still shows total not Avg
In such a case we have to use the old techniques. Use a Line and Stacked Column Visual and adjust the secondary line axis a little bit
Now go to line property and make Stroke Width =0
I want to show the total label in a 100% stacked visual. I need [net] measure as total, which is not available in 100% stacked visual as it only shows %. So first we will create a percent measure
Create a new measure and marked that as a % in measure tools
Brand % = divide([net],CALCULATE([Net], REMOVEFILTERS('Item'[Category])))
Used Brand % on Primary y Axis and Net on secondary y-Axis
Adjusted the y-axis and Secondary y-Axis
if needed you can remove the marker of the line. I have enabled that here
You can find the file on Power BI Community. Please like and share.
Click Here to access all my blogs and videos in a jiffy via an exclusive visual glossary using Power BI.
Please like, share, and comment on these. Your suggestions on improvement, challenges, and new topics will help me explore more.
You Can watch my Power BI Tutorial Series on My Channel, Subscribe, Like, and share
