Forum Discussion

FOPBI's avatar
FOPBI
Frequent Visitor
2 years ago

Date settings in a graph

Hello,

 

I have a graph where the X axis shows the date represented by the number of the week and the month.
When a month ends in the middle of a week, the graph splits the column and shows 2 columns for the same week, but one for each month.

 


Does anyone know how to set it up so that only 1 week column appears and tell the PBI to count columns in a different month, only if the month doesn't start in the middle of the week?

 

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    FOPBI Well you have to come up with the logic under which month that split will show up and add another column in the calendar table that will have the same month for that split week, and then you will use that new column on the x-axis instead of the original month