Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Problem with Running total vizualisation

 Hi,   I am having a problem when graphically displaying my MTD running total sales. I use the following Dax measure that I was able to come up with after reading the http://www.daxpatterns.com/cu...
Need Help
parry2k's avatar
parry2k
Super User
8 years ago

I think your weeknumbers are across all the years and it is combining the data together for all the weeks from multiple years. if you add year and then week number and use drill down all level in hierarchary or create week number with year appended to it and then check.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Wah, that was quick!
    Thank you so much, parry2k, adding the fiscal year did help in displaying the measure for the current fiscal year.

     


    But my objective is to display lines for both current and previous fiscal year for comparison purposes.
    Having the year added does not really allow me to do this as I would get something more like this:



    Which is not ideal...

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      Aha, drop week number on x axis and year on legend. that will do it.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        For some reason, I cannot drop Year on legend, it would not le me do it...