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?

      • vjnvinod's avatar
        vjnvinod
        Icon for Impactful Individual rankImpactful 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")