Forum Discussion

xenbi's avatar
xenbi
Regular Visitor
9 years ago

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,07,08 sequentially, I am not able to get it,  I used the data type Number, it shows from 1st to 31st and if I use the data type Text, it shows the array as 1,10,11,12 etc, but I want to X axis to be from 04th if this month to 8th of next month. It would really be great if you would help me in solving this issue.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    xenbi,

    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