Forum Discussion

sig331's avatar
sig331
Regular Visitor
2 years ago

Using a Slicer, but Filter on a Different Column

I have a slicer for item, my table also has category. I want to add a visual showing other items in the same category based on the item selected in the slicer. I think I need to use SELECTEDVALUE(Item) with a filter based on a boolean column if category = selectedvalue(category), but I can't quite make it work.  Help, please.

 

TIA

Need Help

2 Replies

  • johnyip's avatar
    johnyip
    Solution Sage
    2 years ago

    sig331 ,

    1. Create a calculated table (I will call it 'Table' afterwards) that stores all the unqiue items and their respective category. Leave this calculated table having no relationships with other table. You may also use PowerQuery to create the same calculated table.

     

    2. Use 'Table'[Item] in your slicer.

     

    3. Finally, in your measure, use SELECETDVALUE('Table'[category]) to scan for the respective category.