cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jomikk
Helper I
Helper I

Create a chart from two or more tables with custom filter

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

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @jomikk,

 

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

7.PNG8.PNG


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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @jomikk,

 

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

7.PNG8.PNG


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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors