Forum Discussion
SELECTION SLICER
so the easiest and most sensible option is to unpivot the columns, for this example it works perfectly - but I guess for your main project that causes problems.
The other option would be a custom visual called 'Smart Filter' It allows you to have multiple fields in the same filter:
Failing that, I'm not sure.
if pivoting causes you some issues elsewhere, maybe duplicate the table and pivot that one and create a relationship between the two.I home some of this helps.
so the easiest and most sensible option is to unpivot the columns, for this example it works perfectly - but I guess for your main project that causes problems.
The other option would be a custom visual called 'Smart Filter' It allows you to have multiple fields in the same filter:
Failing that, I'm not sure.
if pivoting causes you some issues elsewhere, maybe duplicate the table and pivot that one and create a relationship between the two.
I home some of this helps.
Thank you for the suggestion Anonymous.
Yes, unfortunately, unpivoting is not an option on my report due to record duplications.
I will try this visual. But I do hope DAX can be an option here.
Thank you!