Tooltip for Stacked Column Chart

[id013]

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 🙂 

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

[v-lid-msft]

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

Best regards,

[Shruthi96]

Hi @v-lid-msft , 

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

[SvenW]

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. 

[id013]

@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 · Accepted solution]

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.

Are you able to get that working in your case?

Regards,

Owen

[id013]

@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.

[OwenAuger]

@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.