Forum Discussion

RSB's avatar
RSB
Microsoft 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
RSB's avatar
RSB
Microsoft Employee
3 years ago

Hi Ashish, Thanks a lot for looking into this. This is how my columns are coming in when I get the data from the excel file into Power BI, not sure how I can link a single date column in Calendar to the multiple date columns. Please advise. Thanks

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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

    • RSB's avatar
      RSB
      Microsoft 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!