For instance, in 2024-Sep, there are like 1,000 as actual and 1,173 as plan. How can I separate them in color coding? I had tried to use the "By dimension" in the "Colors and legend", but didn't work. The system directly make the months with "plan", which are from Sep to Dec, as whole red.
Have you tried to achievie this with a stacked bar chart? There you could use 2 measures, one counting the actual ids and one counting the planned. To these measures you could easily apply seperate colors.