Forum Discussion
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?