Multi-row Card: Impossible to use filters of the visual

[Anonymous]

Hello Everyone,

I'm currently displaying a multi-row card in my report, and I also want to display only the values that are not blank. I tried to use the filter of the visual, but it is impossible to make it work; it's like frozen. Indeed I can't click and change the menu "Show items when the value is:", neither define a value, neither apply a filter. I tried to relaunch PowerBI and create a new visual but it is still not working. Do you have any idea why?

 

Thanks,

Mailys

[lmczach]

I cannot get my multi-row card to have any functioning filters. I have created a measure that returns 1 or 0, added that to the Filters on this Visual but I cannot select the drop down. It is only showing "is less than" with no option to click or fill in a value. 

[v-eachen-msft]

Hi @Anonymous ,

You could set the rule as "is not blank" in the filter pane and apply it.

If it doesn't work, you could share your sample data here if you don't have any Confidential Information. Please upload your files to OneDrive for Business and share the link here.

[Anonymous · Accepted solution]

Hello,

Going through the community and on other websites, I noticed there is no way/feature to sort/filter on measures/DAX. My multi-row card is built based on measures. So I can't select "is not blank".

Unfortunately, my project is confidential so I can't share data.

Thanks.