Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • PijushRoy's avatar
    PijushRoy
    Community Champion

    Anonymous 

    Please share sample data or image for your data structure

      • PijushRoy's avatar
        PijushRoy
        Community Champion

        Hi Anonymous 

        Go to Power Query editor
        Select the all column & Unpivot it

         

        Load the Data, Remove created measure. 
        Create Relationship lick below

         

        Use 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