Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a slicer with filter values: Display 1, Display 2 and Display 3.
I have 4 tables: Table_1, Table_2, Table_3 and Fact_Table.
Table_1, Table_2, Table_3 have Column_1, Column_2 and Column_3 respectively.
I want to create a Table/Matrix.
When I select Display 1 from the slicer, then Column_1 from Table_1 should be displayed long with Revenue and Profit from the Fact_Table.
Similarly When I select Display 2 then Column_2 from Table_2 should be displayed long with Revenue and Profit from the Fact_Table.
Same for Display 3.
Need help in achieving this.
@Anonymous Could you please post the sample data in copiable format and expected output. It will be helpful to understand the scenario without any assumptions rather than descriptive explanation.
Proud to be a PBI Community Champion
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |