Forum Discussion
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.
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/
2 Replies
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/
Hi blopez11 ,
This is something more like this one https://stackoverflow.com/questions/70709095/how-can-i-filter-multiple-columns-that-include-the-same-value-in-power-bi
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
