Forum Discussion
TeyaSax
8 years agoFrequent Visitor
Stacked column chart, how to display total
Need your help! How to find and display the total on the stacked column chart? The chart with the line(measure) unfortunately, is not readable for customers. 1. Values in the legend are constantly...
danextian
Super User
8 years agoWhat I can think of is using a measure as a tooltip that shows the overall total per venuename. The formula is something like
VENUENAME (ALL) =
//calculates the overall total for venuename only, can still be filtered by other columns
CALCULATE (
[Count of patientref measure],
ALL ( 'Table'[venuename] )
)
Or you can use the new page tooltip (still in preview) to show a bar chart showing count of patientref broken down by revenue name and another without a breakdown.
TeyaSax
8 years agoFrequent Visitor
thanks for the advice. unfortunately this is not what I need(