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

Question

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.&nbsp;Example:&nbsp;Description &nbsp; &nbsp; &nbsp; Begin Stock &nbsp; &nbsp; Purch. today &nbsp; &nbsp; Sales today &nbsp; &nbsp; End Stock | Purch. tomorrow &nbsp; &nbsp;Sales tomorrow &nbsp;End Stock tomorrow |Strawberries A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;Strawberries B &nbsp; &nbsp; &nbsp; &nbsp; 1000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 600 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;&nbsp;I will hide row "Strawberries A"

v-ljerr-msft · Answer

Hi&nbsp;janwillem,
&nbsp;
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&nbsp;"Strawberries A" on the Table visual in your scenario.&nbsp;:smileyhappy:
Sum of ALL Measures =
[Begin Stock] + [Purch. today]
    + [Sales today]
    + [End Stock | Purch. tomorrow]
    + [Sales tomorrow]
    + [End Stock tomorrow]

&nbsp;
Regards

opticshrew · Answer

Hi there,&nbsp;I think you could acheive this in a couple of ways:&nbsp;Method 1:Within your report set a page/visual level filter that selects all non 0 values.&nbsp;Method 2:Go into the query editor and filter the rows with the values so there are non 0 values.&nbsp;Thanks,J&nbsp;

janwillem · Answer

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 &lt;&gt; 0.

v-ljerr-msft · Answer

Hi janwillem,
&nbsp;
Have you tried the solution provided above? Does it work in your scenario?
&nbsp;
If you still have any question on this issue, feel free to post here. :smileyhappy:
&nbsp;
Regards

anonymous · Answer

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

Forum Discussion

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

5 Replies

Related content

PowerBI - Matrix table, hide values used only for a visual calculation

Matrix table column Hide

Splitting Column values

Hide column with blank values in matrix

Matching Column Values