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.
Solved! Go to 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/
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
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
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/