The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.