Forum Discussion

mafaber's avatar
mafaber
Helper II
7 years ago

Visualizing series with different X-axis on the same chart

Hi,   my question is not really technical, but a visualizing problem. I have a report containing many KPIs, and one is a hard nut to crack for me. Each quarter closing month (3, 6, 9, 12th month) ...
Need Help
Tutorial Requests
  • mafaber's avatar
    mafaber
    Helper II
    7 years ago

    Hi v-danhe-msft,

     

    I created a data sample file that you can access here: https://drive.google.com/open?id=1oIVn_VKxFP0Fz5383mmCvxM5cGDSMUd_

    You can also find a small explanation for the meaning of the columns in a textbox below the table.

     

    The desired results is just visualizing the KPI in a clear and understandable way, I listed the things I have to see in my post, I don't have a fixed chart type I'd have to stick to.

    The whole problem is that I couldn't visualize Quarter actuals, a Quarter estimate and two full year estimates in a way I'd be satisfied with. :)

    I try to describe things as clear as possible, but please let me know if you have anymore questions :)

     

    Thank you.

     

    Regards,

    Marton

     

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi mafaber,

      From your description, I could not understand how to judge below conditions:

      estimate for the current, non-closed quarter
latest and previous estimate for the full year

      Could you please offer me more detail information?

       

      Regards,

      Daniel He