Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
LillyLegenda
Helper III
Helper III

Tooltip - Show all years

Hi there,

I have this simple bar chart:

LillyLegenda_0-1616146133923.png

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:

LillyLegenda_1-1616146207079.png

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? 🙂

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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"

35.png

 

Best Regards,
Community Support Team _ Eason

 

View solution in original post

3 REPLIES 3
v-easonf-msft
Community Support
Community Support

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"

41.png

42.png

 

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.

 

v-easonf-msft
Community Support
Community Support

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"

35.png

 

Best Regards,
Community Support Team _ Eason

 

Thank you very much @v-easonf-msft.

Unfortuately this is not working.

Here is my example file:

https://file.io/4upwvgZBecG6

 

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.

LillyLegenda_0-1616490033191.png

 

 

Thank you very much 🙂

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.