Forum Discussion
vani
Helper I
9 years agoshow items with no data
Hello guys, I´ve the following visualization: Instead of having Mar/17 and then Mar/20 and want to see those days that i´ve no data ( this case on Mar/18 and Mar/19). I tried the...
- 9 years ago
Try just this:
Sales Last 30 Days = SUM(FACT_INSCRICOES[PRATICANTES])+0
Then use a slicer or other filter to limit your visual to only showing the last 30 days. The +0 will always give 0 if there are no sales for that day.
bblais
Resolver III
9 years agoTry just this:
Sales Last 30 Days = SUM(FACT_INSCRICOES[PRATICANTES])+0
Then use a slicer or other filter to limit your visual to only showing the last 30 days. The +0 will always give 0 if there are no sales for that day.