Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Power BI Community,
I am trying to use a switch to switch between columns. For example, if user selects 1, display column A, else column B. Is there a creative way to accomplish this?
Any feedback is highly appreciated.
Solved! Go to Solution.
@Anonymous,
This can be achieved by creating a disconnect table, You can review the example in the following knowledge base.
https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/ta-p/162635
Regards,
Lydia
The 'solution' link leads to a page that says "You do not have sufficient privileges for this resource or its parent to perform this action." How does one solve this issue?
@Anonymous,
This can be achieved by creating a disconnect table, You can review the example in the following knowledge base.
https://community.powerbi.com/t5/Community-Knowledge-Base/Dynamic-column-based-on-slicer-selection/ta-p/162635
Regards,
Lydia
Hi,
Could you pls let me know how can I access this link, it seems I'm not having sufficient previliges to view this solution.
Thank you.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!