Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Card value not passing through to tooltip

I'm using the new card template (and a stacked bar chart). In the tooltip I want to show the value for the card over all the available years. The card is filtered by: Location  (slicer) Year (slic...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, 

     

    I found a solution.

     

    1. I use a year lookup table for the slicer (year1) 

    2. The corresponding year column in the data table on the chart (year2)

    3. Write a calculation that excludes year1 but keeps year2 and use it on the line chart

    4. Turn on keep all filters, this passes in all filters from the card. The calculation then excludes the year1 filter so that the tooltip can show all years via year2. 

     

    My understanding is that when you pass in all filters this includes any slicers, anything that splits the chart (e.g. legend or categorical axes) and anything on the filter pane. But when you try to recreate that by manually adding columns on the tooltip rather than applying all filters, you cannot pass in anything that is on the filter pane. It needs to be included as something that splits the chart which isn't possible on the card as everything is aggregated. 


    Link to sample workbook https://drive.google.com/file/d/1GfxqDbdaGYwAlKZB3jdP8vNnoY4fMlQV/view?usp=sharing