Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Cumulative chart where the months dont align

Hi there In my dataset Ive got two columns are the original columns Year and Period ( e.g 1 or 2 ....to 12), from this Ive created a "Date" column. The code says that if the Year is 2024 and the Per...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    I'm sorry for misunderstanding you in my last reply, thanks for the file, you can set it up as follows:

     

    1.Change the format of month to "mmmm yyyy", or you can recreate the same column.

     

    2. Under the visualization pane, change the type of x-axis from continuous to categorical.

     

    3. Create a measure that displays the date and place it in the tooltip.

    Date = MAX('TEE01ExtractFileWithHeaders'[Month])

     

    Result:

     

    Best Regards,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Zhu - have replied to this thread. Im quite computer savvy but couldnt find the option to edit the original post.lol

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

 

I'm sorry for misunderstanding you in my last reply, thanks for the file, you can set it up as follows:

 

1.Change the format of month to "mmmm yyyy", or you can recreate the same column.

 

2. Under the visualization pane, change the type of x-axis from continuous to categorical.

 

3. Create a measure that displays the date and place it in the tooltip.

Date = MAX('TEE01ExtractFileWithHeaders'[Month])

 

Result:

 

Best Regards,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.