Forum Discussion

janwillem's avatar
janwillem
Frequent Visitor
9 years ago

How can I hide rows with value 0 (in all columns)

I have a stock overview but I don't want show the 0 values (0 must be in all colums). The values in de columns are measures.  Example:   Description       Begin Stock     Purch. today     Sales to...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi janwillem,

 

If I understand you correctly, you should be able to use the formula below to create a new measure, then use it as a visual level filter("Sum of ALL Measures" is greater than 0) to hide row "Strawberries A" on the Table visual in your scenario. :smileyhappy:

Sum of ALL Measures =
[Begin Stock] + [Purch. today]
    + [Sales today]
    + [End Stock | Purch. tomorrow]
    + [Sales tomorrow]
    + [End Stock tomorrow]

 

Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi janwillem,

     

    Have you tried the solution provided above? Does it work in your scenario?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Thanks for nice trick, Is there a way to hide this measure from the table visual? its not part of the report.