top of page

How to Display Overall Total along with Category in a Viz - Learn Power Query - Part 7

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.

Keep Learning!

183 views0 comments

Recent Posts

See All


The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http


bottom of page