Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lorenz0210
Helper I
Helper I

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors