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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Hiding blank Row and Row Values that are shown as 0.00%

Hi Experts

 

Is it possible no to show row values in a matrix table that are either blank and also 0.00%

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , all blank should not show

Have measure like

If([measure] =0.00 , blank(), [meausre])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anonymous , all blank should not show

Have measure like

If([measure] =0.00 , blank(), [meausre])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

FrankAT
Community Champion
Community Champion

Hi @Anonymous 

you can do it like this:

 

23-10-_2020_16-45-40.png

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

Anonymous
Not applicable

ok thanks Frank is that also possible on Matrix Table too

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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