Forum Discussion
Conditional Formatting - Find/Replace
Hi there, Is it possible to do a find/replace on a grid so that I can create a rule where if the cell in the grid is null I can have a 0 show up instead? I have two tables joined together and one...
Hi Anonymous ,
If what you are trying to do is a visual, you can use a measure:Budget2 measure = IF(MAX(ExpensesTable[Budget])>0,MAX(ExpensesTable[Budget]),0)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Hi Anonymous ,
I am not sure I undertand the constraint you mentioned but have you read this? https://community.powerbi.com/t5/Desktop/Replace-multiple-nulls-at-once-in-Power-Query/td-p/166739
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel