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