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!

      • RSB's avatar
        RSB
        Microsoft Employee
        3 years ago

        Thanks, that worked!