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 quarter...
Need Help
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