Forum Discussion

powerJR88's avatar
powerJR88
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's avatar
    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.

powerJR88's avatar
powerJR88
Frequent Visitor
1 year ago

Thanks Anonymous, but I don't think your solution will help.

 

I have imported 5 tables into Power BI and I am using these tables to do my analysis. 1st table is FY21, 2nd table is FY22, 3rd table is combined FY21&FY22, 4th table is an unpivoted table of projected results and 5th table is the full projected results.

 

This group below utilizes the Combined FY21&FY22 and full projected results tables: 

Whereas this graph has the FY21, FY22 and unpivoted Projected table:

So, how do I put these two graphs together where I can see which portion is US and which portion is India?

 

If you want me to share each table view, please let me know.