PowerBI - Slicer for multiple columns from excel

Ross Shearer 1 Reputation point
2022-06-27T03:57:19.367+00:00

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

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
41,893 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.