Power BI zero values

[Anonymous]

Hello everyone, 

I am very new to Power BI and I am working on a rapport. I want to show prices but I do not want to include zero values. Anyone has any tips for this?

So as seen in the first column, I want a null value and not a $0 

[amitchandak · Accepted solution]

@Anonymous , add +0 to your measure

sum(Table[Value]) +0

in case you want to replace the column value

Or in power query replace null with 0

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

[dcrosseto · Accepted solution]

Hi @Anonymous , you can make the use of Filters side bar.

If you click on the table itself, you will be able to edit the filters on it, like below

With that open, you can filter the measures or dimensions the way you want just by expanding it, for example, let's assume we want to remove all the zeros from "Sum of Doorbelast HB"

Or you want to remove the blanks from "Sum of Tarief HB"

That's a way of doing it, quite simple and intuitive.

Hope it was helpful.

Regards,

Douglas.

[Anonymous]

Thankyou! 

[amitchandak · Accepted solution]

@Anonymous , add +0 to your measure

sum(Table[Value]) +0

in case you want to replace the column value

Or in power query replace null with 0

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk

[Anonymous]

Thankyou!