Un-linking filter/slicers from Tiles on same page

[Anonymous]

Slider / checklist filters (slicers) work at page level. Is there any way I can disassociate selected tiles from the filter, e.g. ensure that a “Grand Total” card always shows the grand total irrespective of filter settings on the page?

[blopez11 · Accepted solution]

Select the slicer, then in the format tab, enable "Edit interactions", then in the card select the none icon (circle with slash through it)

See https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Good luck

[Anonymous · Accepted solution]

@Anonymous -

Your "grand total" card can use a Measure which specifies "ALL" for the relevant filters, like the following:

Grand Total = 
CALCULATE(
     SUM('Your Table'[Your Column],
     ALL('Date'),
     ALL('Product')
)

Hope this helps,

Nathan

[blopez11 · Accepted solution]

Select the slicer, then in the format tab, enable "Edit interactions", then in the card select the none icon (circle with slash through it)

See https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Good luck

[Anonymous]

Thaks for this, the solution works.

BUT once I've "un-linked" the sldier from a visual, I can't seem to re-link it - am I missing something?

[Anonymous]

@Anonymous - Do the same thing you did to disable the interaction, except click the highlighted:

Cheers,

Nathan

[Anonymous]

Hi Nathan,

I don't get the icon you highlioght?1

See STEPS output at https://1drv.ms/w/s!AmxJyApgEAcYgspvIdh7fOqLt0P55Q

[Anonymous]

Ah, may be a different version of Power BI. I'm using the May 2019 version. Does it work to click the "Filter" Icon?