Forum Discussion
zahlenschubser
Helper IV
3 years agoShow zero as blank in visual
I want to show zeros as blank in a visual, but I cannot use conditional text formatting to white because of the alternating colors in the rows. The database is values in period columns, so I don't...
- 3 years ago
You need to use "unpivot columns" in Power Query so you have one column for Date and one column for Amount.
zahlenschubser
Helper IV
3 years agoThat would mean that I need a measure for every separate column. Isn't there a better solution?
DataInsights
Super User
3 years ago
You need to use "unpivot columns" in Power Query so you have one column for Date and one column for Amount.