Hello Team, below is the visual table on my dashboard and the values come from 2 tablesAccount_Listing: FYTD TERTMT Master NEW: Market value and sales I would like to create a filter that allows my users to see the Lates Mareket Vale about $1b and a TER of $100,000 or lessHow can I do that?

vjnvinod not sure how your tables are connected and if these are the measure or what? You need to provide more context. Read this post to get your answer quickly. https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

parry2k Both the tables are connected with many to many relationshipthey 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 filtercompanies Market Value over $1b and a TER of $100,000 or lessnot sure, how to give more context for this

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.

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 mentionedis 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

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?

how to create a filter for table visuals | Microsoft Fabric Community

12 Replies

parry2k
Super User
6 years ago
vjnvinod not sure how your tables are connected and if these are the measure or what? You need to provide more context. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- vjnvinod
  Impactful 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
    Super 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.

Forum Discussion

how to create a filter for table visuals

12 Replies

Related content

Date filters for Visualization

Creating a Date Filter in Power BI

Creating a visual using several filters

Filters issues in visual objects

Filter on Visual Row Context