Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer for sales manager

Hello all,   I have a table of data like this: CustomerID Customer Name Sales 1 Walmart 100,000 2 Winco 102,000 3 Albertsons 99,222 4 Arco 92,002 5 Sams Club 106,150 ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

     

    According to camargos88  description, I made  a demo you can refer to.

    Pbix attached

     

     

    And could you please tell me whether your problem has been solved?
    If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

     

    Best Regards,
    Community Support Team _ Eason

     

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

You can upload both tables and create a relationship between on Customer ID.

 

After that just change the slicer settings on Selection controls to allow the "Select All" option. Also, if u want to remove whe blank row on the slicer, just filter it on filter visual.

 

Ricardo