Forum Discussion
Help with Clustered Column Chart
AndrewDang You have 2 options (each has its advantages)
OPTION 1
Create another Measure using the same formula just change 2015 to 2016
Set Date 2016 = ...... just change 2016 at the end
OPTON 2
You can also create (CY- Current Year and PY - Previous Year) - WATCH the results if you have Year Slicer though !!!
Set Date PY = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), FILTER('DateKey', 'DateKey'[Year] = MAX('DateKey'[Year])-1))
Set Date CY = CALCULATE(COUNTA('Meters Sold vs Set'[Set Date]), FILTER('DateKey', 'DateKey'[Year] = MAX('DateKey'[Year])))
Let me know if this works!
I have tried both options but my line does not seem to change at all. i am not sure if my Date Dimension table is off? I have followed this tutorial to create my date table:
http://community.powerbi.com/t5/Desktop/How-do-i-create-a-date-table/m-p/23896/highlight/true#M7605
No manater what year I changed to, it does not seem to change the result at all.
Do you get the correct result form the Measures I gave you if you put in just a Table?
And post a screenshot so I can see what you have in the Vizualizations and Fields area?
Here is the screenshot with Visualizations and Fields boxes. I had my Date Dimension goes out to 2017 so my current year = max -1; and previous year = max -2. However, the two fomulars return identical results. I have checked my data set and verified that I have set dates in both 2015 and 2016.
Thanks Sean. I really appreciate your help here.
In the Shared Axis try using Month from DateKey? If that doesn't work try removing all other stuff except Month from DateKey and the 2 Measures as in my picture?