Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago

how to create a filter for table visuals

Hello Team, below is the visual table on my dashboard and the values come from 2 tables Account_Listing: FYTD TER TMT Master NEW: Market value and sales I would like to create a filt...
parry2k's avatar
parry2k
Super User
6 years ago

vjnvinod why not use the simple slicer, did you tried it? I'm a bit lost what you are trying to achieve. Did you try slicer? if yes, why it didn't worked?

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago

parry2k 

 

for that i created a measure, like below and try to add this into slicer visual, but its not allowing me to add the measure into the slicer

 

Not sure if there is any restriction for measure to be added into the slicer

 

PotentialOpportunities = IF(SUM('TMT Master NEW'[Latest Market Value (US$)])>1000000000 && SUM(Account_Listing[TER_FYTD_USD ])<=100000, "Potential","OtherCases")
  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    6 years ago

    parry2k 

     

    any feedback? let me know if there is no way out or is it my post which is confusing

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      6 years ago

      v-lili6-msft 

       

      Visual level/page level filter is i am aware. but i dont want to do that, as i want to keep the table as it is and allow users to filter from the slicer

       

      is there anyway i can do that as slicer? (Note: data is coming from 2 different table and they are connected via Many to many relationship)

      i tried creating and measure and reaslised that measure cannot be added to slicer