Create a chart from two or more tables with custom filter

[jomikk]

Hi, apologies for a newbie question, but just started to use Power BI.

So my challenge is that I have data from two or more tables, and I want to show that data in a chart with a custom filter.

So say I have two tables, "A" and "B". When both "A" and "B" is selected in the custom filter I want the numbers to add up to a total of the two.

But when only "A" or "B" is selected, then of course only show the numbers for the corresponding table.

The chart I had in mind was a bar chart or stacked bar chart, where each of the stacks should be "A" or "B".

Hope this was understandable!

Best regards

[v-shex-msft · Accepted solution]

Hi @jomikk,

For your requirement, you can add a custom column to get the table count.

Save and apply the changes, then write a measure to summary the column of table.
After above steps you can use slicer and measure to calculate the total selected table rows.

Regards,

Xiaoxin Sheng