Use data from two or more tables in one chart with custom filter

[jomikk]

Hi, apologies if this is a newbie question, but I am new to PowerBI, and I couldn't find any guides.

Say I have data from two or more tables, for now lets say I have table "A" and table "B", and I want to visualize this in a stacked bar chart.

So I want a custom filter beside the chart, and if both tables are selected, then it should sum up/stack up the total for both tables, but if only one is selected then of course only show the relevant table. I don't want the sum in percentages, but the sum of the values.

How would one go about this? I hope this was understandable, and not too basic.

Best regards

[v-jiascu-msft · Accepted solution]

Hi @jomikk,

A custom filter could be a Slicer visual. If you use a measure to sum the columns up, it will evaluate under the context which you could choose from a slicer. 

The format of the result of "sum up" can be changed in "Data Type".

What kind of data do you have? The details would be varying due to different structure of data.

Best Regards!

Dale