Forum Discussion
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 tried to set it to count only positive or only negeative values.
The second time, the card was again displaying a count of values in a column. The values were text and were either "Up" or "Down" with no other possible values.
In both cases, the option fields below "Visual level filter" were non-responsive. I could't interact with any of the "Show items when the value:" options. The drop-down menu wouldn't drop down, the radio buttons didn't repsonse to mouse clicks, and I couldn't type into either of the text fields above and below the the drop-down.
Any idea what's going on here?
I'm using Power BI Desktop Version: 2.33.4337.281 64-bit (March, 2016) on Windows 10. That's inside of an RDP session from OS X.
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 Yu
15 Replies
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 hmm. This is where I just start trying a bunch of things. 1) start with new visual if you haven't already. If you've tried alot fo things and changed the visual type without deleting it I've seen inconsistant behavior before.. 2) Are you using any custom visuals? Sometimes they create un-predictable behavior.. 3) are you on the latest Desktop version? 4) Does the same behavior persist with other data sets? .. all things I'd check.
Anonymous In the Card - you are displaying a single value!
What are you trying to accomplish? There's nothing unusual about the behaviour you are describing....
Say I have a column with a hundred rows and each row has a number in it. Some positive, some negative.
It's easy to display the count, sum, or average of those values in the card. What I want to do is display the average of ONLY the posistive values or ONLY the negative values. I wanted to use a visual level filter on that card to accomplish that but I couldn't get he visual level filter to work.
I ended up accomplishing what I needed by creating a measure and defined as
AvgOnlyPositives = CALCULATE(AVERAGE([Data], [Data]>0)
But that's clumsy and it now means that the card I created using that new measure doesn't interact with filters or drill-downs with the other visuals.
