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