Forum Discussion

FredLEGUEN's avatar
FredLEGUEN
Icon for Helper III rankHelper III
4 years ago
Solved

Visualize all months, even those with no data

Hi community,   I'm sure this problem has been raised here but impossible to find the answer. I have created a measure to calculate the number of active tickets (no problem) but when I use this me...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    FredLEGUEN 

    It looks like the measure in the 2nd chart is a running total so you should be able to modify that to roll the sum from previous months into a month that is missing data.  A running total measure looks like this:

    Order Count Running Total = 
VAR _MaxDate = MAX ( Dates[Date] )
RETURN
CALCULATE ( COUNTROWS ( Sales ), FILTER ( ALLSELECTED ( Dates[Date] ), Dates[Date] <= _MaxDate ) )
FredLEGUEN's avatar
FredLEGUEN
Icon for Helper III rankHelper III
4 years ago

Thanks jdbuchanan71  for your answer, it solves a part of my problem.

 

As you can see, for this visual, it's exactly what I want 😀

 

But, for another visual, I don't want to have blank bar but I want to repeat the previous bar (so the previous value of the measure). Is it possible to do that ?

 

Thanks