Dynamic columns in table visual based on slicer selection

[Anonymous]

I have a slicer with following value

ID,Name,Category

Need to create table visual where Sales and Profit values remains consistant but based on slicer selection based on slicer selection columns shoould change.

If i select ID then my table visual should consist of ID, Sales and Profit columns.

Kindly do the needfull
Thanks

[ahmetyilmaz]

Hi, you can do it like in this video using bookmark. https://www.youtube.com/watch?v=cFZtUzABOa8

[Abhilash_P · Accepted solution]

Hi @Anonymous ,
You can use Field Parameters in Power BI

Below is the reference 

https://www.youtube.com/watch?v=-nqEv2YXLsU&ab_channel=HowtoPowerBI

Regards

[Kishore_KVN]

Hello @Anonymous ,

You can use field value parameters under parameters under modelling tab in Power BI Desktop and it will help you to fulfill your requirement. 
Please refer below video for the steps:

https://youtu.be/1eurc0EY2Xg?si=HYzys1bSwHzxZnz8

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[grazitti_sapna]

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!