Forum Discussion

Frequent Visitor

1 year ago

Solved

Add country as a stack in clustered column chart

Hi, I have two clustered column charts with metrics from FY21, FY22 and Projected Year. I need to add a country column to the chart where it shows which portion of a particular month is US and t...

Need Help

Tips and Tricks

powerJR88
1 year ago
With the help of a colleague, I realized I just needed to create a couple of appends with FY21, FY22 and Projected Results. I merged the Total Hours (FY21 and FY22) and Hours (Projected Results) into one column, Total Cost (FY21/FY22) and Cost (Projected Results) into another column, and the Ranks into another column. I created a new column called Fiscal Year which differentiated between the year. Then I was able to combine the visuals together.

I'm good for now.

Anonymous

Not applicable

1 year ago

Hi, powerJR88

Based on yur information, I create a sample table:

Then create a stacked column chart, put Date month in X-axis and put FY-21 in Y-axis. Put Region in Legend.

Here is my preview:

However, the data source can only put one value from FY-21, FY-22, and Projected Year on the Y axis

If your data is similar to my example and you want to display all three values, you can Unpivot the three columns FY-21, FY-22, and Projected Year in PowerQuery. I create another table and a new page.