Ability to select where Row Limit is applied on stacked Bar Chart

What is the problem or goal the end user is trying to solve or accomplish?

User has a stacked bar chart and are expecting 5 bars. eg:

classic car - A

classic car - B

classic car - C

Motor - A

Motor -D

Motor - E

Trains - A

Ships - B

Jet - D

Right now, with a row limit of 5, there will only be 2 bars of Classic Car and Motor because the stack are also counted towards the limit

How are they solving it currently?

Create a virtual dataset to hardcode the limit

What is the recommended solution by the Customer?

Ability to choose which part the limit is applied to