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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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