Forum Discussion
Show values greater than selected value from filter
There is a table with single column havong values 1,2,3,4,5.
When I select 3 from filter, I want to dilplay 3,4,5 in table.
Is there any solution?
Hi Anonymous ,
Here's my solution.
Create another table with number. You can create the table directly by entering data or by using the DISTINCT() function to create a calculated table.
Create a measure.
Measure = IF(SELECTEDVALUE('Table (2)'[Value])=3&&MAX('Table (1)'[Value]) IN {3,4,5},1)Add this measure into the table visual, the value column is from the Table (1). Set show items when the value is 1.
When 3 in the slicer is selected. Numbers in the slicer are from the Table (2).
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , if the data type is number then use slicer greater than, there in an option on small down arrow
Hi Anonymous ,
Here's my solution.
Create another table with number. You can create the table directly by entering data or by using the DISTINCT() function to create a calculated table.
Create a measure.
Measure = IF(SELECTEDVALUE('Table (2)'[Value])=3&&MAX('Table (1)'[Value]) IN {3,4,5},1)Add this measure into the table visual, the value column is from the Table (1). Set show items when the value is 1.
When 3 in the slicer is selected. Numbers in the slicer are from the Table (2).
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
