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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
id013
Helper V
Helper V

Tooltip for Stacked Column Chart

Hi,

So I have a stacked column chart that has values color coded by groupings. So when I mouse over the chart, the tooltip only shows the value for the group I am currently mousing over. Is there a way to make the tooltip show the value for all the groups when I mouse over any portion of the chart? I have attached a highely redacted screenshot to illustrate 🙂 

3.png

So for the fiscal period I've selected it only shows my the value of 10 which is the value for group 1, is there a way so that if I mouse over any portion of that column it will show me all values for all groups?

Thanks

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

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.

 

image.png

 

 

Are you able to get that working in your case?

 

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

7 REPLIES 7
v-lid-msft
Community Support
Community Support

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 )
)

 

2.jpg


Best regards,

 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-lid-msft , 

 

Can you help me to get the percentage beside to total value.  Many thanks

Hi @Shruthi96 , were you ever still able to get the percentage beside the total value? I am struggling with the same issue and would like to know if (and how) you solved it. Many thanks. 

@v-lid-msft 

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.

 

OwenAuger
Super User
Super User

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.

 

image.png

 

 

Are you able to get that working in your case?

 

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

@OwenAuger 

Thank You !!!! This solution worked magnificently. Thanks. One thing I did notice though that when I drag the fiscal period fields into the tooltip fields, all the visuals that have tooltip set to report page -> auto now display the new tooltip instead of the default. Is that normal? Either way I can get around it by setting those to default instead but I was just curious if that's a bug or on purpose.

@id013 Glad that worked for you 🙂

 

I expect that's meant to be a "helpful" behaviour, but I can see that it might not be desirable.

It may depend on which fields are present in the visual(?)

Yes I expect you are stuck having to change to default manually.


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!