Segmentation for tables

[Fabirana]

Hello,

I have two tables...

"Table1" and "Table2" with a lot of dates and columns, both tables with the same structure...

Both tables with a field named "Quarter"

I want a matrix comparing the field "Incomes" bau I want a table filtered with a specefic quarter and the other one with other quarter, but I want it in the same table.

I want a segmentation to filter one table and another segmentation for the other table.

Table1 = FILTER(DATOS,DATOS[YearMonth]="2021Q4")

Table2 = FILTER(DATOS,DATOS[YearMonth]="2022Q1")

2021Q4 and 2022Q1 I want select them in two segmentation because I have a lot of quarters and I dont want to edit them.

Thank you very much.

[Fabirana]

Thank you very much,

it was enough.

[v-jingzhang · Accepted solution]

Hi @Fabirana 

As both tables have the same structure, you can first combine them into one single table with Append Queries feature in Power Query Editor. Click Transform data in Home ribbon, you will open Power Query Editor. Ensure the column names in both tables are consistent before appending. After appending, click "Close&Apply" to load the table.

In Power BI Desktop, add two table visuals and two slicers to the canvas. Put Quarter column into both slicers. Select one slicer and click Edit interactions in Format ribbon. By default, a slicer will affect all visuals on the same page. However, you can change this behavior with Edit interactions  feature. In below image, I select the right slicer and make it filter only the table below it. For the left slicer, I make it only filter the left-side table. So you can see both tables are displaying data in different quarters. 

I have attached a sample file at bottom. Hope it helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.