Dynamic columns in table visual based on slicer selection

Hi Anonymous,

you can use Filed parametes to switch between fields, Go to Modeling → New Parameter → Fields and create a parameter with the required columns.

Here is the DAX to create the same

ColumnSelection =
{
("ID", NAMEOF('SalesData'[ID]), 0),
("Name", NAMEOF('SalesData'[Name]), 1),
("Category", NAMEOF('SalesData'[Category]), 2)
}

Now create table visual, as ColumnSelection, Sales and Profit.

Use field parameter in slicer, now when filtering the slicer table values will update as per the selection.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!