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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
piotr_gor
Helper II
Helper II

Stacked column chart hover on one column and show all data in tooltip

Hi,

 

I've created simple stacked column chart. I've got two values: sales in 2019 and sales in 2020.

Dark part of visual are sales in 2020 and lighter in 2019.

 

If I hover over darker part of chart in tooltip I get only value of sales in 2020. But I'd like to get value of 2019's sales too. How do I do that? It isn't just simple draging sales in 2019 to tooltip cause if I hover over values in 2019 and get these values double. 

 

Also, is there a way to remove title "Dates Day" which appears in tooltip? I just want to see date without, no legend next to it. 

 

How do I achive what I want? 

 

It's so simple yet I'm stuck. 

 

piotr_gor_0-1646163958670.png

 

1 ACCEPTED SOLUTION
VahidDM
Super User
Super User

HI @piotr_gor 

 

Check these links:

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @piotr_gor 

 

You can try the following methods.

Measure:

2019 =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALL ( 'Table' ),
        YEAR ( [Date] ) = 2019
            && [Project] = SELECTEDVALUE ( 'Table'[Project] )
    )
)
2019 =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALL ( 'Table' ),
        YEAR ( [Date] ) = 2019
            && [Project] = SELECTEDVALUE ( 'Table'[Project] )
    )
)

Put the two measures in the tooltip bar.

vzhangti_0-1646380784134.png

vzhangti_2-1646380852104.png

Does this match your expected output? Also you can't delete "Dates Day" if you want to, because it is part of the view.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VahidDM
Super User
Super User

HI @piotr_gor 

 

Check these links:

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips

 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: 
www.linkedin.com/in/vahid-dm/

 

 

It helped. Thanks. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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