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...
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:
you cannot have two values if you want to use legend, remove one and then try with year in legend, also in that case you can remove year from x axis.
I have 2 values (the 2 measures I want to compare)
- MTD Running Total Sales- Prev MTD Running Total Sales
Here's a screenshot:
here is the thing, you cannot compare two values and also have legend. either you have to remove one value and use legend.