Forum Discussion
zahlenschubser
Helper IV
Helper IVShow 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...
You need to use "unpivot columns" in Power Query so you have one column for Date and one column for Amount.
DataInsights
Super User
Super User
Try this measure:
Amount =
VAR vAmount =
SUM ( Table1[Amount] )
VAR vResult =
IF ( vAmount = 0, BLANK (), vAmount )
RETURN
vResult
In the Values field well, click the down arrow for Amount and select "Show items with no data":
zahlenschubserHelper IV
Helper IVThat would mean that I need a measure for every separate column. Isn't there a better solution?
- DataInsights
You need to use "unpivot columns" in Power Query so you have one column for Date and one column for Amount.