Forum Discussion
Impactful Individualhow to create a filter for table visuals
Super Uservjnvinod 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.
Impactful Individual
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
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
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")