Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |