Forum Discussion

Fabirana's avatar
Fabirana
Frequent Visitor
4 years ago
Solved

Segmentation for tables

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 fi...
  • v-jingzhang's avatar
    4 years ago

    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.