I'm starting with Power BI and I've seen a lot of posts related to this but using measures and what I need is a calculated column (or a measure that acts like a calculated column).
How can I make a slicer ignores all the active filters in the report? I need this in order to add a dynamic legend to a line chart. Below I describe how I have my report so far.
The blue highlighted slicer is the one I used to assign the legend to the line chart (as you can see in the DAX in red), I need an additional slicer (the green one), no matters if it use the same column (if that is possible) or a new one, that can shows all the data although the blue one is filtered.
Why I need this, because the blue one should filter some things in the report and the green one should act like the dynamic legend selector ignoring the filters applied in the blue one.
Thanks a LOT in advanced!
Based on my test, I am afraid you could not use the two same slicers to filter different value in one visual, but I suggest you to switch the "Single Select" off and you could select multiple options in one slicer and show in the same value.