How to Cluster Quarters for Comparison Year over Year

[Anonymous]

Trying to replicate a basic pivot table from excel.

Data:

	Q1	Q2	Q3	Q4	Average
F2020	57	10	17	65	37
F2021	56	15	12	50	33
F2022	38	4	3	0	0

Pivot table in Excel:

Clustered bar chart in Power BI clusters all the quarters + average in a year together.

I've tried different fields for the Axis, Legend and Values. This format is the closest I can get (Axis is Year, no Legend, Values are Quarters).

What am I missing?

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

You need to unpivot other columns in Power Query first.

Then use these columns in Clustered bar chart.

Like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[Anonymous]

That's got me sorted, @v-janeyg-msft . Many thanks!