Forecasting Visuals

[desmon316]

I have a data that shows business over 4 or 5 years. We are awarded the contract in year 0. We calculate the spread of the amount over the duration of the contracted project. 

While using Excel, I can use charts which portray the data as column chart separated by space and driven by the column and no other data.

In PowerBI, I have to use clustered or stacked columns. In clustered columns, all the columns are attached to each other and concentrated in the middle. Is there any way that I can spread those out over the window, without using any non numerical distinguishers? In short I would want the data to look as the image attached.

[v-cazheng-msft]

Hi @desmon316,

You mean you want something like the following picture but Clustered column or Stacked column chart couldn’t fulfill? As you can see, the following char is created with Clustered column chart which is similar to the screenshot from you.

If I misunderstand your needs, please feel free to let me know. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[desmon316]

Hi @v-cazheng-msft 

Thank you for your response.

I plan to create something similar as shared by you. My understanding may be low, if I use clustered charts, with the data as the sum of a column, I get: 

Now I understand if I were to bring in a non numerical foreign key, I can split it as:

 I would want to slice the data by the Business Unit and just show the data split spread over the window.

To clarify: As we have projects which spread over years, I can not add specific FY as a field.

Hope I have tried to clarify our situation.

Regards

Desmond

[desmon316]

Hi @v-xiaoyan-msft, @v-cazheng-msft 

Is there a solution for this?

In PowerBI:

 in Tableau:

in Excel using Pivot Table:

Sum of Columns.

Is there something I am doing wrong to get the output similar to excel or Tableau.