Forum Discussion
Problem with visual level filtering on card
Hi Anonymous,
As the Card dispalys only one value which has been aggregated always, we are not able to add a filter condition based on this aggregate value ("Average of Values"). When the specified fields under Visual level filters pane contain more than one value, then we can set filter condition like yellow highlighted section via Advanced filtering. Take a look at this article: How to use report filters.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
I am indeed trying to filter down the count. Good way to put it.
Nice suggestion; I just tried creating a table and applying a visual level filter to it. I encountered the same problem: the selections for the visual level filter are non-respsonsive, aka "frozen."
This is starting to seem like a bug.
Anonymous think of the Card as a Matrix or Pivot Table
but you've only put a Measure in the Values area and nothing on Rows or Columns
so it gives you 1 number as expected => based on what should it give you options to filter???
You'll have to drag another column in the Visual Level Filters for the Card => then you can filter your Measure based on that Column
I think I understand what you mean. I can't filter the based on the values in the field that I'm displaying in the card.
That would be a nice feature to have, though.
Anonymous Go in your table and Create a New Column
Test Column = IF (TableName[ColumnName]>0, "Pos", "Neg") => reference the column that has the number +/-
Then create your card - with the Card selected drag the Test Column in the Visual Lelel Filter of the Card
Then tell me if you can Filter by Pos and Neg
Yes, I can indeed filter by Pos and Neg. This is similar to the solution I came up with using a measure and CALCULATE() with a filter for values>0.
This will certainly work. I just wish I could use that visual level filter differently.
What's that "Show item when values:" section even for? When should I be able to interact with it? See screenshot.