Forum Discussion
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) Language - English Languaged - Spanish...
amitchandak
Super User
Super UserRednut , Assume those values coming from an independent table
You can this measure in slicer or visual level filter
measure =
var _1 =selectedvalue(Language[Language])
var _2 = Switch(_1 ,
"English", filter(Table, Table[Language - English] = "English") ,
"Spanish", filter(Table, Table[Language - Spanish] = "Spanish")
)
return
calculate(countrows(Table), _2)
Thank you for the response. I receive the error "the expression refers to multiple columns. multiple columns cannot be converted to a scalar value". Does column B and C need to have the same title? (i cant have 'Language - English' as the title of column B and 'Language - Spanish' as the title for column C?)
