Forum Discussion
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...
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...
Aha, drop week number on x axis and year on legend. that will do it.
For some reason, I cannot drop Year on legend, it would not le me do it...
do you have more than one field in values? you have to have one field in values, can you send screen shot what kind of field you have on axis, value, legend?
I have 2 values: