Forum Discussion
make table unaffected by slicer except one column
Anonymous , Can you use interaction instead.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Greg_Deckler this returns the correct value when i put it into a card visual. but when i add it to the table the value reverts back to the unfiltered value. Thank you for your efforts its greatly appreciated
Community ChampionAnonymous - Hmmm, thinking about this, you may have to reverse the logic. Make the slicer affect the visual. Write a measure for each column that you don't want to be affected by the slicer that uses ALL or ALLEXCEPT for example.
I think the reason is that once the slicer does not affect the visual, any measure executing within the context of the visual loses all context for the slicer. So, from the context of the visual, the slicer is always "all" in effect. Painful.
Greg_Deckler I cannot all or allexecpt to work, how would you suggest writting it for a category column?