Forum Discussion
webportal
9 years agoImpactful Individual
Display empty values in area chart
I've given up trying to define a measure that returns the bank account balance and cash flow, even for days when there are no movements. After lots of different combinations, I realized it's not wort...
- 9 years ago
Hi,
I've figured out I must have a value for each day in my dates range for the ending balance.
Otherwise, charts and visuals in general will look terrible.
This is the expression I've managed to find:
Saldo em EUR = IF ( AND ( 'Consolidado'[DataCorrente] <= 'Consolidado'[DataMáxima]; 'Consolidado'[DataCorrente] >= 'Consolidado'[DataMínima] ); CALCULATE ( 0 + SUM ( 'Consolidado'[Fluxo em EUR (intermédio)] ); FILTER ( ALL ( 'Calendário'[Data] ); 'Calendário'[Data] <= MAX ( 'Calendário'[Data] ) ) ) )Initially, a simple measure but required to define intermediate calculations.
Now, the charts are looking better: