Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Hi @Gokul_Saraboji ,
You can use Field Parameters in Power BI
Below is the reference
https://www.youtube.com/watch?v=-nqEv2YXLsU&ab_channel=HowtoPowerBI
Regards
Hi, you can do it like in this video using bookmark. https://www.youtube.com/watch?v=cFZtUzABOa8
Hi @Gokul_Saraboji ,
You can use Field Parameters in Power BI
Below is the reference
https://www.youtube.com/watch?v=-nqEv2YXLsU&ab_channel=HowtoPowerBI
Regards
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!!
Hi @Gokul_Saraboji,
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!