Challenge getting multiple columns ‘grouped’ on a Clustered bar chart or a Stacked column chart

[Abelardusca]

Hello,

I am uploading data in Power BI from Excel to show data using either a bar chart or a column chart. The Excel table (data source) below shows numbers (already calculated in percentages) pulled from another Excel tab. Values are pulled into a tab that is more flat for Power BI.

TIERS	RANK	VENDOR	3 MTH	4-6 MTH	6-9 MTH	9-12 MOTH	12 PLUS MTH
1	1	A	97.43%	97.16%	84.25&	94.44	92.73%
1	2	B	100.00%	98.00%	#N/A	87%	78%
1	3	C	98%	100%	69%	100%	88.75%
1	5	D	87.23%	98%	68%	88%	100%
1	8	E	87%	98%	100%	100%	98%
1	12	F	98%	88%	78%	98%	100%

I tested using Power BI charts with another Excel data that shows whole numbers (quantity of defects), and the charts grouped all the five time periods (fields) per vendor (graph below in Power BI); however, when using data showing in Excel as percentages, the Acceptance ‘Rate’, graphs don’t group periods per vendor.

When I use values in percentages, the charts don’t group the data as per the view above. I tried ‘Unpivoting” the columns to have a better format; however, it does not work since Power BI rejects the duplicated values resulted from the Tiers field (same value = 1) after unpivoting the columns.

GOAL: To get the view shown above or below where the time periods in percentages are grouped for every vendor/supplier (view above from Power BI is using whole numbers; view below is the actual chart in Excel using values in percentages).

Please let me know how I can achieve the grouping of periods either transforming the data in a different way in Excel or using DAX or other ways.

Thank you!

Danika

[lbendlin]

Apart from some needed cleaning on your sample data this looks straightforward?

see attached