Forum Discussion
Card value not passing through to tooltip
- Anonymous2 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
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523