Forum Discussion
Matrix - Show Blank instead Zero
Hey, @lordtopcat
You don't need to create 12 measures for each column whose value is zero, you can try replacing zero with null in Power Query Editor, you can follow this:
- Open Power Query Editor, select the columns you want to display in visual, and the columns used in the measures you created to display in visual.
(You can hold down ctrl and left click on all columns that you want to achieve multiple selections), like this:
- Click 'Replace Values', from '0' to null, like this:
And you can see that all zero values will be blank in the visual.
Best regards
Qin Community Support _Robert Team
If this post helps,then consider Accepting it as the solution to help other members find it faster.
Hey, @lordtopcat
You don't need to create 12 measures for each column whose value is zero, you can try replacing zero with null in Power Query Editor, you can follow this:
- Open Power Query Editor, select the columns you want to display in visual, and the columns used in the measures you created to display in visual.
(You can hold down ctrl and left click on all columns that you want to achieve multiple selections), like this:
- Click 'Replace Values', from '0' to null, like this:
And you can see that all zero values will be blank in the visual.
Best regards
Qin Community Support _Robert Team
If this post helps,then consider Accepting it as the solution to help other members find it faster.
If I do it this way I get errors in the query editor because the columns are configured as decimals. =(