Forum Discussion

Juv_a's avatar
Juv_a
New Member
2 years ago

Chart

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?

Need Help

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    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's avatar
      Juv_a
      New Member
      2 years ago

      Hi Pijush

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

       

       

      • PijushRoy's avatar
        PijushRoy
        Community Champion
        2 years ago

        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