Forum Discussion
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
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
4 Replies
- grazitti_sapnaSuper User
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! - Kishore_KVNSolution Sage
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!!
- Abhilash_PSuper User
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 - ahmetyilmazAdvocate II
Hi, you can do it like in this video using bookmark. https://www.youtube.com/watch?v=cFZtUzABOa8