Forum Discussion
Solved
Filtering in visual element?
Hi, i have a table with columns delta and amount. I want to show only the Top 5 rows ordered by amount desc but only where delta>20. Is there a way to directly achieve this in the visual element (tab...
Hi _chris_,
Did not understand that part of the question, go to the Delta column and filter all that are above 20 even if delta is not part of your visual table you can filter the table taking that into account.
In the example below I only have 4 deltas above 20 so the list is not giving me the top 5 but 4.
This is making a simple use of the tool, you can also create some measure to make this to work, but believe that this simple soluition is better for begining to understand the filters options you have.
Regards,
MFelix
try to set these filters in the visual level filter
where TotalAmount is a measure: =SUM( Data[Amount] )