Forum Discussion

vidhyasankar's avatar
vidhyasankar
Frequent Visitor
7 years ago
Solved

Actual Vs Target Visual by Week

Hi,

 

 

I'm looking for a visual to achieve the below result.  I tried differnt in-built and market place visuals but didn't work out.  Can you please suggest how I can acheive this?

 

 

Thanks a lot for your help!

 

Sankar

  • vidhyasankar's avatar
    vidhyasankar
    7 years ago

    I finally managed to achieve this using Bullet Chart and slicer for weeks.  Thought of sharing the same as it might be useful for others.

     

     

     

    Dataset for achieving the above.

     

     

    Thanks a lot!

     

    Sankar

4 Replies

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

    Hi Sankar,

     

    If the whole parts are your goal, I'm afraid I don't know how to create it. Can you share a dummy sample file and input some explanations. 

     

    Best Regards,

    Dale

    • vidhyasankar's avatar
      vidhyasankar
      Frequent Visitor
      7 years ago

      v-jiascu-msft,  Thank you for your response!  I believe the above requirement (to have both actual / target and weeks in axis) is not technically possible.  I came close to what I need with the Bullet chart (1.8.1) with the exception of weeks.

       

      This is the dataset for the chart.  Let me know if there is anyway to bring in the time / week into the chart.

       

       

      Thanks a lot!

       

      Sankar

      • vidhyasankar's avatar
        vidhyasankar
        Frequent Visitor
        7 years ago

        I finally managed to achieve this using Bullet Chart and slicer for weeks.  Thought of sharing the same as it might be useful for others.

         

         

         

        Dataset for achieving the above.

         

         

        Thanks a lot!

         

        Sankar