cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
oldhasbeen Regular Visitor
Regular Visitor

Un-linking filter/slicers from Tiles on same page

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?

2 ACCEPTED SOLUTIONS

Accepted Solutions
blopez11 Established Member
Established Member

Re: Un-linking filter/slicers from Tiles on same page

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

natelpeterson New Contributor
New Contributor

Re: Un-linking filter/slicers from Tiles on same page

@oldhasbeen -

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

6 REPLIES 6
blopez11 Established Member
Established Member

Re: Un-linking filter/slicers from Tiles on same page

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

natelpeterson New Contributor
New Contributor

Re: Un-linking filter/slicers from Tiles on same page

@oldhasbeen -

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

oldhasbeen Regular Visitor
Regular Visitor

Re: Un-linking filter/slicers from Tiles on same page

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?

natelpeterson New Contributor
New Contributor

Re: Un-linking filter/slicers from Tiles on same page

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

Edit Interactions - Enable Interaction.PNG

Cheers,

Nathan

oldhasbeen Regular Visitor
Regular Visitor

Re: Un-linking filter/slicers from Tiles on same page

Hi Nathan,

 

I don't get the icon you highlioght?1

 

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

natelpeterson New Contributor
New Contributor

Re: Un-linking filter/slicers from Tiles on same page

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

Edit Interactions - Enable Interaction - 2.PNG