Forum Discussion
Dynamic change in X Axis
I am new to Power BI arena, Please someone help me to sort out the problem addressed below: In the screenshot, in X axis column, I am trying to define the dates from 04,05. ....31, 01,02,03,04,05,06,...
It is not possible to display the dates from 04,05. ....31, 01,02,03,04,05,06,07,08 sequentially in X axis in the above chart as Power BI will automatically summarize the values of July collections/June Collections for Day 4,5,6,7,8 no matter what data type you define for the Day column.
To work around this issue, you can add prefix to the values of the Day column to distinguish Day 4,5,6,7,8, then add anther index column in your table.
After that, click Day column in the Fields pane, and click “Sort by column ” to choose “Index” , you will be able to sort the Line chart as expected.
Regards,
Lydia
Thank You