How to show a 'table' visual that shows the data columns and the totals for each column

[Anonymous]

This question may apply for how to build filters for such a structure as well.

I have a data structure that looks like this: partnumber, date, field1, field2, field3.

The "field" columns contain a 1 or a 0 (or null) depending on whether there is a value.

The "field" columns are summed to get a total of ech partnumber & date

In powerbi I build line charts that show the total of each "field" by date.

My question is how can I show a Table visual that shows each "field" and their totals.  Also howcan I also create a filter on "field" so that you can either show all "fields" in a combined line "field"chart or an individual "field's" line chart?  I hope that make sense.  I can try to give an example if needed.  I would think building the filter on date is easy, but on Column name of field?

Thanks!

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

You can create measures to calculate taotal values of each fields as:

Best Regards,

Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

here is an example of what I would like the table visual to look like: 

and the data looks like: 

Thanks!

[amitchandak]

@Anonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.

You can all for in table visual, that will show data date wise and grand total(if enabled) 

Show only Fields in the table, it will show the total of only

Show only Fields in the Matrix, it will show the total of only(use "Show on Row")  -https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

Appreciate your Kudos.