Slicer from 3 different columns

[Anonymous]

Hi,

I have 3 different status from the table and I want a slicer from all the columns.

"Avaliable_Status" , "Active_Status" and "Not Active_Status".

Here is the sample data.

[v-jayw-msft]

Hi @Anonymous ,

Check the formula.

Table 2 = DISTINCT(UNION(SELECTCOLUMNS('Table',"slicer",'Table'[column1]),SELECTCOLUMNS('Table',"slicer",'Table'[column2]),SELECTCOLUMNS('Table',"slicer",'Table'[column3])))

Best Regards,

Jay

[Anonymous]

@v-jayw-msft ,

I tried the same way but this is not working .

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

The formula is to create a slicer table.

If you want the slicer to filter the visual, you will need to create a measure as below.

IF(SELECTEDVALUE('TABLE'[PCI])=SELECTEDVALUE('SLICER'[COLUMN])||SELECTEDVALUE('TABLE'[SOC])=SELECTEDVALUE('SLICER'[COLUMN])||SELECTEDVALUE('TABLE'[SOC FC])=SELECTEDVALUE('SLICER'[COLUMN]),1,0)

Then put this measure to visual level filter measure = 1.

Best Regards,

Jay

[amitchandak]

@Anonymous , You can create a new table like

distinct(union(distinct(Table[Avaliable_Status]) ,distinct(Table[Active_Status]), .distinct(Table[Not Active_Status])))

Join with all three columns and create measure using use relationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

Another option is unpivot table

https://radacad.com/pivot-and-unpivot-with-power-bi

[Anonymous]

@amitchandak ,

I have created a seperate table for distinct values.

When I am trying to establish the relaptionship I am getting error.