PowerBI - Slicer for multiple columns from excel
I'm trying to create a dashboard that has multiple answers for a slicer to filter on a single table of data from Excel.
for example;
Column A (person) | column B (language A) | Column C (language B)
John | english | spanish
Fred | english | {blank}
Bill | {blank} | spanish
I want to be able to set up a slicer that has English & Spanish as options in the slicer and will filter the table to show anyone who speaks english or spanish
IE: if you select 'english' it would show John & Fred but not Bill. If you select spanish, it shows John and Bill and not Fred.
I would like to have the above for multiple queries in the one dashboard. language(s), occupation(s), car(s) etc