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
gonzaloh
New Member

Having a hard time dealing with blanks

Hello!

 

I am currently struggling with handling blank values in the measures that I have created in my data model. My objective is to hide the measures that contain blank values, as shown in the image. Despite trying to utilize filter visuals, I have not been able to resolve the issue. I have also read that Power BI automatically hide blank values, but this does not seem to be the case in my situation.

 

I apologize, but the information is in Spanish. However, I have attached a sample file for you to reviewhttps://1drv.ms/u/s!Au-Btoirlv-YgtADHtbJuWeVMEz9TQ?e=aEXZ0L

 

gonzaloh_1-1683653046645.png

gonzaloh_2-1683653095215.png

 

I believe that this issue may be due to a lack of fundamental knowledge on my side. As a result, I have turned to this forum to seek assistance. As a newcomer to the Power BI world, any advice or guidance you can provide would be greatly appreciated.

 

Thank you!

2 REPLIES 2
Kishore_KVN
Super User
Super User

Use filters on this visual option and add that measure in that field then apply filter using non blank. 

I believe I attempted that approach previously, but unfortunately, it did not work. Would you mind show me to see if it produces the desired result? 

 

Thanks!

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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!