Forum Discussion

jomikk's avatar
jomikk
Icon for Helper I rankHelper I
9 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    9 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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