cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
n4tusi4
Regular Visitor

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

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_2-1656071883798.png 

n4tusi4_3-1656071965502.png

 

 

1 ACCEPTED SOLUTION
blopez11
Memorable Member
Memorable Member

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/

View solution in original post

2 REPLIES 2
n4tusi4
Regular Visitor

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 

n4tusi4_0-1656659183669.png

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:
n4tusi4_1-1656659238223.png -> n4tusi4_2-1656659262741.png

 

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

n4tusi4_3-1656659368301.png

 

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. 

n4tusi4_4-1656659500073.png

 

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
Memorable Member
Memorable Member

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/

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors