Parameter controlled visual and filtering the tooltip

"Context" is whats important when solving Power BI Dax challenges.  If we break the problem down into the idea of what conext do you find yourself in and what context do you want to show.  If you can articulate that, the solution should be much easier to build.

When you are hovering over a visual, the context your find yourself in is that Year/Quarter as well as the metadata you are using to create your groupings, which from your screenshots are numbers like 11, 146, 48.

So if you run a measure that does something like 

Gross Revenue = SUM('Sales'[Value])

your outcome is going to be in that context. My example of course it not yours, just keeping it simple.

If you want to ignore some of the context, this is where you'll need a new measure that ignores specific parts of the context.  For example:

CALCULATE(
     [Gross Revenue],
     FILTER(
          ALLSELECTED('Calendar'[Month])
     )
)

This will run the gross profit measure but ignore the table's filtering of the "Month" column from your table without ignoring the filtering of other data table columns, like financial year.  The ALLSELECTED still obeys your page's overarching filtering, so you aren't going to get literally everything.

Bringing this back to your example and what I was talking about of Context.  What metadata columns are being filtered when your tooltip appears that you would like to expand?  Can you write a new measure to put into your tooltip table that lets you use something like ALLSELECTED to expand the context outward to where you want?

Hello jjustjjo 

try with this measure

Count CERs Tooltip =
CALCULATE(
COUNT(<unique ID>),
NOT('Table'[STATUS] IN {"R","W"}),
REMOVEFILTERS('Table'[Active-Completed]),
REMOVEFILTERS('Table'[CER Status])
)

pankajnamekar25 , Anonymous Thank you both for your replies.  I tried these and they do not resolve the problem.  I suspect the issue resides in the fact that that the chart changes based on the parameter  View By.  Because of this the context changes depending on which view of the chart is shown. I will try to mock up an example to post.

Anonymous  pankajnamekar25 I'm not a power/super user, so I can't post files (that's helpful, not).  Waste of my time to create an example of the exact scenario and I can't post it.  I probably can't share my company one drive account so that's out too.  I guess it will just go unsolved.  

Hi jjustjjo,
Thank you for posting your query in the Microsoft Fabric Community Forum.

I was able to reproduce your scenario in Power BI Desktop, including the field parameter (View By), stacked column chart, and tooltip behavior.

After testing, I was able to achieve the expected output based on your requirement:

• The tooltip respects the Year/Quarter context
• It ignores the legend (Active/Completed) filter
• It always shows the full breakdown (both Active and Completed) regardless of which segment is hovered

The solution involves:

• Creating a base measure for correct calculation
• Using REMOVEFILTERS() to eliminate legend context in tooltip scenarios
• Separating tooltip logic from split measures (Active / Completed)

This ensures the tooltip behaves consistently even when switching between Year and Quarter using the parameter and For your reference, I’ve attached a sample .pbix file that demonstrates this setup and behavior. You can use it to compare with your model and adapt accordingly.

Best regards,
Ganesh Singamshetty

Hello jjustjjo,

Hope everything’s going great with you. Just checking, the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

Hello jjustjjo,

Could you please confirm whether your query has been resolved or if the shared suggestions helped address the issue? Your confirmation would be helpful for other community members who may encounter a similar scenario in the future.

Thank you for being part of the Microsoft Fabric Community.

Best regards,
Ganesh Singamshetty