Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I have this simple bar chart:
I would like to add a waterfall diagram in the tooltip to give more insight but when I hover over one bar I only get this result:
This makes sense because I am hovering over 2019 therefore this is applied as a filter.
I think it is possible to use ALL in Dax but I cannot get it to work.
VolumeAllYear =
CALCULATE (
[Volume],
ALL ( 'Date'[Year] )
)
Can you please help me with that? 🙂
Solved! Go to Solution.
Hi, @LillyLegenda
Can you share a sample pbix file for testing?
Which field is used as the tooltip field?
You can take a try to change the option from 'show tooltip when Summarized' to ' show tooltip when used as category' and turn off the option "Keep all filters"
Best Regards,
Community Support Team _ Eason
Hi, @LillyLegenda
Since the URL you shared seems to have expired, I made a new demo for reference.
Please recheck the tooltip field you are using. And make sure you have turned off "Keep all filters"
Please check the attachment for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @LillyLegenda
Can you share a sample pbix file for testing?
Which field is used as the tooltip field?
You can take a try to change the option from 'show tooltip when Summarized' to ' show tooltip when used as category' and turn off the option "Keep all filters"
Best Regards,
Community Support Team _ Eason
Thank you very much @v-easonf-msft.
Unfortuately this is not working.
Here is my example file:
I would like to be able to hover over Midwest 2019 and see in the tooltip: Waterfall Tooltip filtered on Midwest but see all years and the difference.
Thank you very much 🙂
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |