Forum Discussion

Community Champion

7 years ago

Solved

SELECTION SLICER

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
7 years ago
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.

4 Replies

Anonymous
Not applicable
7 years ago
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
  Community Champion
  7 years ago
  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
    Not applicable
    7 years ago
    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.

Related content