Forum Discussion
Display different monthly data depending on the month using SWITCH
Anonymous,
So your requirement is that you don't want other chart be filtered by slicer chart, right? You can click Format-> Edit Interactions and then click right-top hand of other visuals, click disable icon.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yuta-msft ,
Thanks for replying.
Not exactly, I don't want my table to be affected by that month slicer but I want my SWITCH function (used in the table) to be affected.
Since the SWITCH depends on the month selected.
That's why I was thinking about an intermediate table or something ...?
Because I need the table to display all the months (therefore not being filtered) and the SWITCH to be affected by the month slicer (because it displays different data depending on the month selected.
Best regards,
Benjamin
Anonymous ,
"
That's why I was thinking about an intermediate table or something ...?
Because I need the table to display all the months (therefore not being filtered) and the SWITCH to be affected by the month slicer (because it displays different data depending on the month selected.
"
Have you tried the way above? To disable visual be filtered by slicer, you should click "Edit Interaction" and then click "Disable icon" in the visual.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for answering.
If a disable the relationship between my visual, the SWITCH function is not working anymore.
I figured out that what I was trying to achieve was not possible (both remove relationship with filter while having my DAX formulas affected by the filter).
Then I gave up.
Regards
Benjamin