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(T...
Need Help
Show and Tell
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.