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.
to fully understand what you're trying to do.
are you only wanting to show the VALUE where you have data in SELECT1, SELECT2, SELECT3?
Do you have a mockup (even in Excel) what you want the output to look like?
Thanks.
Hi Anonymous ,
I have a link of the power BI report sample.
The output is if I select Select1, all the value column with select1 will show. same with select2 and select3.
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!