Forum Discussion

manishbeniwal's avatar
manishbeniwal
Frequent Visitor
7 years ago
Solved

How to show missing month in chart

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi manishbeniwal 

    You may try to create a measure with IF Fuction like below:

    Measure =
IF (
    MAX ( 'Table'[date] ) <= DATE ( 2019, 3, 31 )
        && MAX ( 'Table'[date] ) >= DATE ( 2018, 4, 30 ),
    SUM ( 'Table'[Amount] ) + 0
)

    Regards,

manishbeniwal's avatar
manishbeniwal
Frequent Visitor
7 years ago

By this feature it is showing all 2018 and 2019 months in X-axis. I want to start X-axis from Apr 2018 and last month will be Mar-19.

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
7 years ago

Add +0 to your sum. 

Measure = Sum(Table[Amount]) + 0