Forum Discussion
Display all values in table
Hi everyone, i need help with this,
i have slicer with diffrent categories like fruit, vegetables and meat,
when i select fruit in slicer it will display all fruit i have in friut column,
my dax looks like:
switch(True()),
selectedvalue(categories)="fruit",Values(fruit))
then i got a error message like:
A table of multiple values was supplied where a single values was expected
5 Replies
- PijushRoyCommunity Champion
Anonymous
Please share sample data or image for your data structure- AnonymousNot applicable
yes here is sample pbix :
https://www.dropbox.com/s/8ad4q1j4rk4y5fs/sample.pbix?dl=0- PijushRoyCommunity Champion
Hi Anonymous
Go to Power Query editor
Select the all column & Unpivot itLoad the Data, Remove created measure.
Create Relationship lick belowUse the slicer to get resulted data
Keep the same spelling for Vegetable in both table
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos