Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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...
vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful Individual
6 years ago

parry2k 

 

Both the tables are connected with many to many relationship

they are not measures, they are coloumns (TER value is coming from Account Listing table and Market value is coming from TMT Master NEW)

 

I am just trying to create a filter where where users can quickly filter

companies Market Value over $1b and a TER of $100,000 or less
not sure, how to give more context for this

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    vjnvinod interesting, did you tried using page-level filter and add these conditions as a filter and see if you get the correct result before we proceed further.

    • vjnvinod's avatar
      vjnvinod
      Icon for Impactful Individual rankImpactful Individual
      6 years ago

      parry2k 

       

      I don't want to create a page level filter, as i want to give the user  the ability to filter the data with the criteria i mentioned

      is there anyway to do that?

       

      if not is there anyway i can highlight those rows, which meets my criteria, tried looking at conditional formatting, that doesn't really helps, you need to sum the TER value and also Market value and highlight the rows

       

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper 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?