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

[janwillem]

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 today     End Stock | Purch. tomorrow    Sales tomorrow  End Stock tomorrow |

Strawberries A            0                      0                     0                       0                    0                             0                           0 

Strawberries B         1000                     100                 500                   600                                              600                            0 

I will hide row "Strawberries A"

[v-ljerr-msft]

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. 

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

Regards

[Anonymous]

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

[v-ljerr-msft]

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.

Regards

[opticshrew]

Hi there,

I think you could acheive this in a couple of ways:

Method 1:

Within your report set a page/visual level filter that selects all non 0 values.

Method 2:

Go into the query editor and filter the rows with the values so there are non 0 values.

Thanks,

J

[janwillem]

I doesn't work, the columns are all calculated values. I can't put the calculated value not in the "Page level filters" to filter with <> 0.