How can I filter multiple columns that include the same value in Power BI?

[n4tusi4]

Hello. I would love to have such filter as marked below which would work for 7 columns at once and would give at least one matching result per row. For example I choose status "pending close" an it will show all possible pending close even if on the same row will be another status for another column (like on 2nd picture). I will be thankful for more detailed explanation. Thank You for Your time.

 

[n4tusi4]

Hi @blopez11  ,

This is something more like this one https://stackoverflow.com/questions/70709095/how-can-i-filter-multiple-columns-that-include-the-same...

I have created new table 

And added following expression

Status in slicer = SUMMARIZE(UNION(VALUES('Period Status'[GL_Status]), VALUES('Period Status'[PO_Status]), VALUES('Period Status'[AP_Status]), VALUES('Period Status'[AR_Status]), VALUES('Period Status'[FA_Status]), VALUES('Period Status'[RL_Status]), VALUES('Period Status'[PA_Status])),'Period Status'[GL_Status])

What gave me following result:

 -> 

And here I have a problem with second step mentioned in added link , namely how to create a measure

I have clicked on field Status in slicer and then "new measure" and when I write PickThis then it is treated as a name for this column. 

Even if I start with name of measure SELECTEDStatus , there is nothing like 'PickThis' command. Could You please help me how to handle this step? Many thanks

[blopez11 · Accepted solution]

Take a look at the following from the sqlbi folks and see if it may meet your need

https://www.sqlbi.com/articles/creating-a-slicer-that-filters-multiple-columns-in-power-bi/