Forum Discussion
make table unaffected by slicer except one column
Hi all,
is it possible to have a table (execpt one column ) completely unaffected by the slicers on a page?
I have a table with two columns 1.a list of products 2. the sales for those products.
I want to add a third column called 'sales for selected period'
I want the list of products and the sales columns to remain unaffected when I use a date slicer but I want the sales for selected period column to change.
is this possible?
Anonymous , Can you use interaction instead.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
11 Replies
- amitchandak
Super User
Anonymous , Can you use interaction instead.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
amitchandak right, but I still have a column in the table I want to change when I use the date slicer
- Greg_Deckler
Community Champion
Anonymous - Yes, don't have your slicer connected to your visual. (Edit Interactions) Create a measure for the one value in your visual that grabs the value(s) in the slicer and returns a result accordingly.
Greg_Deckler I am using a relative date slicer, what would be the best approach to create the meaure? If has one value?
thank you!
- Greg_Deckler
Anonymous - It's really hard to say. You should be able to do something like:
Measure =
VAR __SlicerValues = 'SlicerTable'[SlicerColumn]
RETURN
...
Once you have the values, you can get the min or max of those and filter by these min's and max's or you might use IN operator. Hard to say without knowing your data and what you are trying to calculate.
