'How do I create a slicer that only affects one column in Power BI?
I have a table with multiple columns, I would like to add a "Previous Date Slicer" so that there is a column that will fetch data from previous dates that the user selects, but it applies this slicer to the entire table so I can't actually create a comparative column and the entire table is filled with data from the dates I have selected.
The intent is that the Previous Data Column will display the information from the previous dates I selected in the slicer column, creating a comparison. One column will have the current dates data, and the other column will have the previous dates data from dates the user specified.
Solution 1:[1]
you should be able to do this by "Edit Interactions" feature.
When you have the slicer highlighted you will see a "Format" pane in the top many and the first button on this page is the one you want. One you enabled "Edit Interactions" some extra icons will apear on the other objects and all object is by default set to filter. You can change the object you don't want to be filtered by the slicer to "None"
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Charfeddine Mohamed Ali |