bar chart with custom x axis

[Kiniaczek]

Hello,

I want to show visualization of the shop shelf on the bar chart. I know current stocks and name of products, also an order of products. If the product could be only in one place at the shelf I would simply make chart like:

values - stocks

x axis - names of products

and sort names of products by product order.

Unfortunately a product can lay on two or more different parts of the shelf so I can't sort by product order.

I would like to have a chart of 'stocks by product order' but instead of showing 'product order numbers' show 'product names' on x axis (so the same values on X axis can occur multiple times)

Regards

[Kiniaczek]

I solve the problem by concatenating product name and order. But it doesn't look nice to have strange number in label.

Do you have any other ideas?

[v-deddai1-msft · Accepted solution]

Hi,

There is no way to show the repeated values separately on the X-axis. I suggest you rename product column as 'shelf + prodcutname' to  distinguish duplicate values.

As a workaround, you can use shelf column in legend, Although duplicate values are still merged, you can distinguish them by color and tooltip.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai