Forum Discussion

Kiniaczek's avatar
Kiniaczek
Icon for Helper I rankHelper I
6 years ago
Solved

bar chart with custom x axis

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 ...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    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

Kiniaczek's avatar
Kiniaczek
Icon for Helper I rankHelper I
6 years ago

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's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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