I have a bar chart that is showing amounts formatted in millions (if amount greater than 1 million) or direct amounts (if amounts less than 1 million)
When applying sorting, the values are sorted correctly although the million amount bar lines are smaller at the top than the direct (without million formatting) amounts shown on the chart.
This results in direct amounts showing bigger lines at the bottom. Any way to fix this?
