Forum Discussion
Tooltip for Stacked Column Chart
Hi there,
It looks like you can do this if you use a Report Page Tooltip but not a regular tooltip.
I have shared a PBIX here with a very simple example.
The key thing is to set up the Tooltip Report Page so that the Keep all filters = Off and the filter you want to be passed (e.g. Fiscal Period) dragged to the Tooltip fields well.
Then only the Fiscal Period will be passed through as a filter to the tooltip.
Are you able to get that working in your case?
Regards,
Owen
Hi id013 ,
We can create a measure and use it in tooltips field to meet your requirement:
Tooltips Measure =
CONCATENATEX (
SUMMARIZE (
CALCULATETABLE (
DISTINCT ( 'Table'[Legand] ),
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[X-axis]
IN FILTERS ( 'Table'[X-axis] )
)
),
'Table'[Legand],
"TotalValue", CALCULATE (
SUM ( 'Table'[Value] )
)
),
[Legand] & ": " & [TotalValue]
& UNICHAR ( 10 )
)
Best regards,
Thank you very much for your suggestion. I will keep that in mind for other situations but in this case I felt the other suggestion would be easier to implement as I don't want to be creating too many measures in this case.
