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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Gokul_Saraboji
Helper II
Helper II

Dynamic columns in table visual based on slicer selection

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

1 ACCEPTED SOLUTION
Abhilash_P
Continued Contributor
Continued Contributor

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

Abhilash_P_0-1741674986589.png


Below is the reference 

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

Regards

 

View solution in original post

4 REPLIES 4
ahmetyilmaz
Advocate II
Advocate II

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

Abhilash_P
Continued Contributor
Continued Contributor

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

Abhilash_P_0-1741674986589.png


Below is the reference 

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

Regards

 

Kishore_KVN
Super User
Super User

Hello @Gokul_Saraboji ,

 

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
Super User
Super User

Hi @Gokul_Saraboji,

 

you can use Filed parametes to switch between fields, Go to ModelingNew ParameterFields 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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors