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
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.
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 YuAh, I see. Thank you, v-qiuyu-msft. I understand what you mean.
I appreciate the response and good customer service.
Hi v-qiuyu-msft,
I have a simple card that is running a headcount. It will be filtered eventually by various slicers (demographic data). I need to filter the card to display a count only when that count is >= 10 due to federal reporting laws. Is this possible? I can't think of a way to write a measure as such, and can't filter the card this way. I also have tried this as a table and am having the same issue.
Thank you!
-Katy
What did you try for your measure? Would something like this work in the card instead?
(haven't tried it so there may be a syntax error)
HC Card Measure = IF([Headcount] >= 10, [Headcount], "NA")