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

Thanks for the concern from Ritaf1983.

 

Hi Anonymous ,

 

Noticed you didn't follow up with a reply, has your issue been resolved yet, I couldn't reproduce your issue during my testing process :

Measure = CALCULATE([Profitmeasure],FILTER(ALL('financials'),'financials'[Date]<=MAX('financials'[Date])))

 

 

If your problem is not solved, please provide a more detailed description or a pbix file with sensitive data removed, this will help the problem to be solved faster!

 

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.