SELECTION SLICER

[mussaenda]

Hi,

I don't know how to deal with this,

I have this sample data, i just want to have a selection slicer to based on select 1, 2 and 3.

I cannot unpivot them because i don't want the value to duplicate.

Is there other way using DAX?

here is the pbi file: test selection pbix

Thank you!

[Anonymous]

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.

[mussaenda]

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.

[Anonymous · Accepted solution]

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.

[mussaenda]

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!