Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

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 1
PattemManohar
Community Champion
Community Champion

@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.





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors