Sales by Category is a common bar chart.
It can be vertical as well
Subcategory may be added by creating a hierarchy between Category and Subcategory
Bars can be sorted in ascending/descending order based on any measure and any aggregation.
When there is hierarchy, you may order any levels of hierarchy separately.
For example, Category, ascending order by SUM([Sales]). Then subcategory descending order by SUM([Sales])
Category, ascending order by SUM([Sales]). Then subcategory descending order by AVG([Days to Ship])
By editing tooltip, and adding Quick calculation (Percentage of Total for Sales), we get customized tooltip.
Percentage of Total in the whole categories:
Percentage of Total in the current category