cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Help Needed: How to add another stack column from a different data source/ table

Hi, Everyone. 

 

I am trying to add an additional stack column on the existing data from a different table. Currently I created a pipeline from Sept. 2019 to Present. Since fiscal year is over, I am trying to add another stack column for 2021 pipeline from a different table. I tried to append the 2021 pipeline table to the existing table but it did not show the "2021 Projected Pipeline", instead created another stack column for each month of 2021. 

Is it right to append the data or create a different table? and connect a relationship?

 

My goal is: 

* To show the existing data from 2019 to 2020 by month and add the 2021 Projected Pipeline. 

* To show 2021 Projected Pipeline with different legend and data color. 

 

Here are some illustrations: 

               2021 Projected Pipeline

lorenz0210_0-1604517187181.png

lorenz0210_1-1604517245938.png 

lorenz0210_2-1604517370295.png

 

 

Badly needed help as I am stuck on this for 2 days in a row. 

 

Thank you so much. 

 

0 REPLIES 0

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors