cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Switch for column instead of measure

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Switch for column instead of measure

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Switch for column instead of measure

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.