Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Plot zero when there is no data in cumulative graph

Hi guys,

 

I made the following cumulative graph:

 

 

And used the following measure:

 

 

Measure = IF(SELECTEDVALUE('DateTabel'[Date]) > CALCULATE( LASTDATE(Tonnage_table[Day]), ALL(Tonnage_table)), BLANK(),
                            CALCULATE( SUM(Tonnage_table[Tonnage]),
                                        FILTER(ALLSELECTED('DateTabel'),
                                        'DateTabel'[Date] <= MAX('DateTabel'[Date]))))

 

 

Now i would like to show zero when there is no data and start over with the cumilative graph like i show below in red line.

The results should look like this :

 

 

 

 

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous ,

    Create measure +0 if needed

    Measure 10 = IF(SELECTEDVALUE('DateTabel'[Date]) > CALCULATE( LASTDATE(Tonnage_table[Day]), ALL(Tonnage_table)), BLANK(),
                            CALCULATE( SUM(Tonnage_table[Tonnage]),
                                        FILTER(ALLSELECTED('DateTabel'),
                                        'DateTabel'[Date] <= MAX('DateTabel'[Date]))))+0

     

     

    Change type to categorial

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      What is +0 supposed to do ?

       

      When I changed to categorical and use inteval year then its not is the graph not readable anymore, on top of that it dosent give me the desired result.