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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

how to prevent zero values are displayed.

in the picture below I have a report that it have some measures and fields, as you can see has lines all values are zero, thus leaving the report with unnecessary size, how can I prevent these zero values are displayed?

 

Untitled.png

3 REPLIES 3
Sean
Community Champion
Community Champion

@Anonymous Use the Visual Level Filters => show when greater than 0

 

Anonymous
Not applicable

@Sean

when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?

@Anonymous

 


@Anonymous wrote:

@Sean

when I do it even if it is just a measure of the other columns are zeroed only presenting the total, do not have a way to get it to display the values as I want without having to filter the report?


The visual level filter only affects that visualization and it won't filter the report. May I know why a filter is not preferred in a visual? Up to my knowledge, there's no other way than a filter. Or you may prefer a filtered calculated table or a filtered dataset when connecting the data source?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.