How to custom stack bar stack squeeze?

[Andrewlu18]

I have 3 columns, `Date`,`Level`, `Qty`.

I want get stack bar chart, Data is X-Axis, Qty is Yaxis, Level as different type to stack, but stack squeeze is High/Low/Med,

I want to use Low/Med/High Squeeze, how to do?

I build a Level dim-table base one this Squeeze, and build relationship with fact-table, use dim-data level column as type, but get data is wrong.

`Data table`

Date	Level	Qty
5/1	Low	312
5/1	Med	236
5/1	High	456
5/2	Low	872

`Level`

No.	Level
1	Low
2	Med
3	High

[TomMartens]

Hey @Andrewlu18 ,

I assume this is what you want:

Here the Level column from the dim table is used. To get the order sorted, it's necessary to sort the Level column by the No. column: Sort one column by another column in Power BI - Power BI | Microsoft Learn

Hopefully, this provides what you are looking for.

Regards,

Tom