Actual Vs Target Visual by Week

[vidhyasankar]

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

[v-jiascu-msft]

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]

@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 · Accepted solution]

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

[v-jiascu-msft]

Thanks for sharing, Sankar. 

Best Regards,

Dale