cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vitexo87 Member
Member

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 Super Contributor
Super Contributor

Re: how to prevent zero values are displayed.

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

 

vitexo87 Member
Member

Re: how to prevent zero values are displayed.

@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?

Moderator Eric_Zhang
Moderator

Re: how to prevent zero values are displayed.

@vitexo87

 


@vitexo87 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
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,107)