Clustered bar chart

There are one clustered bar chart. In the x-axis, there would be values (per filter). In the y-axis, there would be Product ID, the Product ID has 2 values, one is the number of manufactured products, the second one is the number of sold products. Manufactured products are in the column of sheet “Manufacturing”, Sold products are in the column of sheet “Sales”. There are 5 Product IDs only.
Problem: as I move ProductID from sheet “Manufacturing” to the chart, data of that sheet is right, but not the data from sheet “sales”, the data from sheet sales is showed as the total and unchanged no matter how I maneuver the time filter.
Here is the picture


Thank you for your supports!

Hi, it’s a bit hard to tell what’s going on here, as the screen shots have labels in another language but by the looks of it, all the numbers on the left chart with the red lines are the same indicating that you don’t have a correct data model setup. Please check out Sam’s video on the topic or upload a sample file so we can see what’s going on.

Thanks,
Tim

1 Like

Thanks Tim,
it helps me solve the problem, I just have to change cross filter direction from single to both.


1 Like

One more thing, How could I change the Date filter from “mm/dd/yy” to “dd/mm/yy”. Thanks alot

Not sure about the date question. Be careful with many to many relationships, they can cause inaccuracies. Be sure to double check the output is as expected, ideally your data model should only have one to many relationships. Pleas accept my answer as a solution if it solved your issue!

Here is the picture, I want to change the period from “5/26/2023-9/30/2023” to “26/5/2023-30/9/2023”. Thanks Tim