filter out 0 values in visualisations

[laernouts]

Hi,

We have a visual in Power bi which shows the balance (value) per ledger account.

In Power BI we have calculated the current value with the journal entries.
There is a year filter. If there is 2021 selected it shows the last calulated value of 2021. If 2022 is selected it calucaltes the last value of 2022 (the current value).

The problem is the visualisations show all the ledger account that have an entry in the selected year. There are a bunch of ledger accounts that have a current value of 0 but they are shown in the visualisation.
We have tried the simple method of filtering out the 0 in the visualisation but it didn't work.

Is there a solution in DAX to filter out the zeros?

[amitchandak]

@laernouts , On is use visual level filter measure <> 0

another is to create a measure like 

if([Measure] =0 , blank(), [Measure])