Forum Discussion

Julian_H's avatar
Julian_H
Helper II
3 years ago

Sorry the data is sensitive but here's a mock up

Account Name 1Name 2
123JohnPeter
456MaryDavid
789PeterPaul

 

So from the slicer(s) the user for example wants all data where Name 1 = John and Name 2 = Paul

 

So in this instance you would get a list showing account no's 123 and 789

Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

Hope this helps:

 

  • Julian_H's avatar
    Julian_H
    Helper II
    3 years ago

    Cool Thank you so Much.. I'll give it a go

     

    • Padycosmos's avatar
      Padycosmos
      Solution Sage
      3 years ago

      Slicers Name1 and Name2 are created from the columns in the newly created Tables Name 1 and Name 2

      Table: 

      Name1 = VALUES('Table'[Name 1])

      Table: 

      Name2 = VALUES('Table'[Name 2])