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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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