Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Single slicer for multiple column multiple categories

Main Table:   Customer Type Customer 1 Name Customer 1 BU Customer 2 Name Customer 2 BU Customer 1 Owning User Customer 2 Owning User Customer 1 Created By Customer 2 Created By Conta...
DAX Filtering
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Have you considered unpivoting your table (by adding the customer id as a column)?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This is the report view that I have shown above. I have a column named 'external_id' that can individually identify customer 1 & 2 if that's what you are referring to. lbendlin