Forum Discussion
Power BI zero values
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
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
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.
4 Replies
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
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.