Tooltip does not ignore Keep all filters for one visual ?

[Anonymous]

Hi everyone,

I'm encountering an issue in Power BI and would appreciate your guidance.

I want to create a tooltip with the following:

1. Current Value: The value at the point where my cursor is (based on the selected Country, Indicator, and Date).
2. Trend Chart: A chart that shows the evolution of this Indicator over time (fixed to the same Country and Indicator as the tooltip, but displaying values for all dates)

I disabled "Keep All Filters" and passed Country and Indicator as values in the "Drag tooltips fields here" section.
This approach almost works but results in Blank values instead of the expected data.

The first one would be the value at the current point (for the Country, Indicator and date on which my cursor is) 
For the second one, it would be a chart which shows the evolution of this indicator (so for all dates, I should have the same figure, it should take the Country and the indicator as parameter)

Here’s the formula I’m using to handle the blank issue:

MyMeasure=

CALCULATE(

    [ValueAdj],

    FILTER(ALL('Test Main Table'),

    'Test Main Table'[Date] = SELECTEDVALUE('Test Main Table'[Date])))

When I re-enable "Keep All Filters," the tooltip shows the correct values, but my line chart only displays a single point instead of the full trend.
I came across a workaround suggesting duplicating the table and using it for the line chart, but this breaks the filtering by Country and Indicator in my visuals.

How can I modify my approach to correctly capture the data for the current date without losing the filtering for Country and Indicator?

Thanks in advance for your help!

[123abc]

I think you’re trying to create a dynamic tooltip in Power BI that shows both the current value and a trend chart for a specific indicator. The challenge you’re facing is maintaining the correct filters while displaying the trend over time.

Please try below steps:

1. Create a Separate Measure for the Tooltip:

   • Use a measure that calculates the current value based on the selected filters (Country, Indicator, and Date).
   •  

   CurrentValue =
   CALCULATE(
       [ValueAdj],
       FILTER(
           ALL('Test Main Table'),
           'Test Main Table'[Date] = SELECTEDVALUE('Test Main Table'[Date])
       )
   )

2. Create a Trend Chart Measure:

   • Create a measure that calculates the trend over time, ignoring the Date filter but keeping the Country and Indicator filters.

   TrendValue =
   CALCULATE(
       [ValueAdj],
       REMOVEFILTERS('Test Main Table'[Date])
   )

3. Set Up the Tooltip:

   • In the tooltip page, add the CurrentValue measure to show the value at the current point.
   • Add a line chart visual and use the TrendValue measure to show the trend over time. Ensure that the Date field is on the X-axis.

4. Configure the Tooltip:

   • Disable “Keep All Filters” for the tooltip page.
   • Drag the Country and Indicator fields into the “Tooltip fields” section to ensure they are passed correctly.

By using REMOVEFILTERS in the TrendValue measure, you can ensure that the trend chart shows data for all dates while still respecting the Country and Indicator filters. This approach should help you display the correct values without duplicating tables or breaking the filtering.

[Anonymous]

It is not working

I adapted the current value, to check returned the selected date, but it is returning blank all the time

current 

CALCULATE(

    Max('Test Main Table'[Date]),

    FILTER(

        ALL('Test Main Table'),

        'Test Main Table'[Date] = SELECTEDVALUE('Test Main Table'[Date])

    )

Any other idea ?

[Anonymous · Accepted solution]

Hi @Anonymous ,

I created a sample pbix file(see the attachment), please check if that is what you want.

1. Create a separate date dimension table

2. Create a measure as below to get the sum of values by date

Measure =
VAR _date =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Test Main Table'[Value] ),
        FILTER ( 'Test Main Table', 'Test Main Table'[Date] = _date ),
        REMOVEFILTERS ( 'Date'[Date] )
    )

3. Create a tooltip page: Create report tooltip pages in Power BI - Power BI | Microsoft Learn

4. Configure the tooltips settings

Best Regards