Forum Discussion

vani's avatar
vani
Icon for Helper I rankHelper I
9 years ago
Solved

show 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...
  • bblais's avatar
    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.