Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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?

 

Need Help

3 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      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?

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee
        10 years ago

        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?