Forum Discussion
% change from previous time stamp
Anonymous the formulas work fine as is. The current problem is that the chart has an axis with individual dates so it presents very spikey. It calculates a big increase on the 1st of the month because the data in fact table is all as of the first of the month and then an equally large decrease on the 2nd.
Once Anonymous makes the adjustments to the visualizations I suggested they'll have a month to month representation and they'll be fine.
I am also okay to settle for MTM change but even then it does not look right.
Community ChampionDoes this look better?
In the PBIX I downloaded yesterday, you have the date in the x axis of the chart. You should do two things:
- Create a hierarchy of Year, Month and Date
- Make sure Month is sorted by MonthOfYear (in data view, select the column, Ribbon > Modeling > Sort by Column)
Once the hierarchy is created, remove date from the axis and put the hierarchy there. Drill down one level to month.
- littlemojopuppy
By the way...you also should replace the axis of the bigger chart at the top left with the hierarchy as well. And change the date used in the slicer to the date field in the date table.
So i tried doing this and things went crazier than normal. Maybe i could try remaking the Calendar table using some good dax that you may have? My date hierarchy is being difficult.
- littlemojopuppy
I have requested access