Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Problem with visual level filtering on card

I've tried to set a visual level filter on a card twice this morning and encountered a problem.   The first time, the card was displaying a count of values in a column. The values were numbers. I t...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    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

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.