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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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