Forum Discussion
Conditionally Render Columns from Different Table
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.
1 Reply
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.
