Chart

[Juv_a]

I want to create a graph of revenue target vs actuals quarter wise. The challenge with my raw data is that there is a separate column for each quarter where revenue numbers are added. To have quarters on X axis, I need revenue for each quarter where quarters are mentioned  in rows instead of columns.

Hope my issue is understandable. Is there a way to possibly fix this?

[PijushRoy]

Hi @Juv_a 

if you can share a sample data format or image, it would be helpful
Also please share the exact visual you are looking for 

[Juv_a]

Hi Pijush

Here is the sample data and chart. Need monthwise and quarter wise

 

 

[PijushRoy]

Hi @Juv_a 

Can you please try to unpivot the column and create the visual? ATTACHED PBIX

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin