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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
marcelojunior88
Regular Visitor

How do I hide a line that doesn't have values?

I'm making an array that has 3 levels of rows. These levels come from three different dimension tables. I would like that when level 2 has no information (blank line), it does not show it, but yes the next level that is not blank. I've put an example below.

 

marcelojunior88_2-1703156685977.png

 

1 ACCEPTED SOLUTION
marcelojunior88
Regular Visitor

Hello, the solution didn't work , but I was able to get around it by filling in the null values of hierarchy two, with the values of hierarchy three.
Thanks!

View solution in original post

2 REPLIES 2
marcelojunior88
Regular Visitor

Hello, the solution didn't work , but I was able to get around it by filling in the null values of hierarchy two, with the values of hierarchy three.
Thanks!

VijayP
Super User
Super User

@marcelojunior88  Try using IF(HASONEVALUE(COLUMNNAME),measure) to get the result required




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
MY Blog || My YouTube Channel || Connect with me on Linkedin || My Latest Data Story - Ageing Analysis

Proud to be a Super User!


Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors