Forum Discussion

RSB's avatar
RSB
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Creating a Line and Stacked column chart using matrix/pivot data source

Hi, I'm pretty new to Power BI. Wondering if somebody can guide me on how to take the below data and create a Line and Stacked column chart . The x-axis should show the Month-Yr and  Y axis should ha...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Please go through the steps in the Query Editor to see the transofrmations carried out.

RSB's avatar
RSB
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

That worked really well. How can I have Category-1 & Category-2 as stacked values and Category-3 & Category-4 as Lines charts. Thanks!

    • RSB's avatar
      RSB
      Icon for Microsoft Employee rankMicrosoft Employee
      3 years ago

      Thanks, that worked!