While Presenting Any Report you must keep the Audience in view because they are your customers and you need to incorporate their requirements into your reports.
But if the requirement is bit tricky then it will become bit difficult to make the report the way the recipients want.
Power Query is so Powerful for that matter and it can manage Data Transformation with trickiest situations. If you know bit of M-Query then you can do magic.
In this video I have explained how to accommodate both
- Values by Category ; and
- Sum of those all values (Overall Total)
in the same bar chart.