Forum Discussion

Natalia1234's avatar
Natalia1234
Regular Visitor
6 years ago

Single filter to filter different columns

Hi,  I am new to Power BI and really need your help with this: I have data like this: Column A Column B Column C A not B not C not A B C A B not C I would like to have ...
Need Help
Natalia1234's avatar
Natalia1234
Regular Visitor
6 years ago

Unfortunately, this is not the case, cause I have observations with A in one column and B in the other, while in your example continent, country and region forms a unique combination (we can not have an observation with Asia as a continent and France as a country in the same time). Moreover, the slicer will have options "A, not_A, B, not_B", and I what I need is "A, B".

 

Maybe there is a measure that would be equal to the selected option in filter?

dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

Hi Natalia1234 , 

I am not clear about your requirement, If you choose "A" in slicer, what is your expected output? You could use your original table, filter value only to "A" and "B", then use this as slicer.

If possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.