Forum Discussion

id013's avatar
id013
Helper V
6 years ago
Solved

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 ...
Need Help
  • OwenAuger's avatar
    OwenAuger
    6 years ago

    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

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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,

 

id013's avatar
id013
Helper V
6 years ago

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.