Forum Discussion
Helper IStacked Area Chart - Inconsistent Display
KrisW,
What field do you drag to the X-Axis of these charts and which table does the field come from? If you only want Month-Year to be displayed, you can create a MonthYear calculated column in the table, then drag it to X-Axis of your charts,
Regards,
Lydia
KrisW,
What field do you drag to the X-Axis of these charts and which table does the field come from? If you only want Month-Year to be displayed, you can create a MonthYear calculated column in the table, then drag it to X-Axis of your charts,
Regards,
Lydia
Helper II am using a "transaction date" field, displaying hierarchy for year & month. I am begining to think that a calculated character field might be the only means of achieving consistancy in the display. Just a tad resentful that I might have to re-write the code generating nearly 50 reports to add the column for Power BI.
I also noted that quarters seemed to be assumed according to calendar year, I might need to add a calculated field for that as well.