Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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

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?

 

Screen Shot 2020-07-07 at 11.02.43 AM.png Screen Shot 2020-07-07 at 11.03.04 AM.png

 

Thanks,

 

Mailys

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

3 REPLIES 3
lmczach
New Member

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
Community Support
Community Support

Hi @Anonymous ,

 

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

2-1.PNG

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Anonymous
Not applicable

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.