Forum Discussion

KeepCalm007's avatar
KeepCalm007
Helper I
8 years ago

Hi Ashish_Mathur , 
apologies, that is the old version of my PBIX file. The problem I was experiencing before, you can see in August column, for 'Lower North' , the grey area in July did not carry through to August. - it is supposed to be cumulative. So the August column should also show grey data from July.

 

That was fixed with the help of v-ljerr-msft 's formula, until I downloaded the latest version of Power BI desktop, and things stopped working. Not sure why

Now all the months show cumulative result to date - instead of to the month itself - but no measures had been altered.

This is the current PBIX file - If I can fix it on the main graph, I can surely duplicate the method to the other smaller graphs.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    I have revised my formula in that file.  The download link is the same.

     

    Please check and revert.

  • KeepCalm007's avatar
    KeepCalm007
    Helper I
    8 years ago

    Hello Ashish_Mathur

    Thank you very much for having a look. Your measure looks very clever, however this is looking similar to the original problem - which was that the light grey does not appear as it should on the last cumulative column. The September column is supposed to show 'Cases closed' from July to September inclusive. It's quite puzzling why the data does not show as one would expect :/

     

     

  • KeepCalm007's avatar
    KeepCalm007
    Helper I
    8 years ago

    Greetings Ashish_Mathur

     

    The light grey is now showing on the last month! :)

     

    However, the future months in the year do not show on the x-axis anymore. Is this the only way the formula is able to work? 

     

     

    Thank you and regards for your help

  • KeepCalm007's avatar
    KeepCalm007
    Helper I
    8 years ago

    Hello Ashish_Mathur

    Again, thank you so much for your help! This is what I want to achieve regarding the months showing on the x-axis - Showing up to the last data month, leaving future months showing blank :

    Unfortunately the calculations used to achieve this don't work anymore after I downloaded the latest update of power bi desktop - which is the reason for my follow-up post on 10-23-2017 - The post you replied to.

     

    If you look at my post on 10-23-2017, that is what happened after refresh.

     

    Is it possible for your method to show the future months blank?

     

    Regards