Forum Discussion
Power BI zero values
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.
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.
Thankyou!