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

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.