Dynamic Field Change

[Anonymous]

Hi All,

I am very new to Power BI. Please help and support me.

Based on Above selection, the field in the below Metrics Table should change from Account Code to Account Name.

Thanks in Advance 🙂

[Anonymous · Accepted solution]

@Anonymous 
Try the following steps, it might change the model, so you can test on a sample or duplicated table first.

1. Hold on Shift to selected both Code and Name columns,

2. Unpivot columns, Close and apply.

3. Use the Attribute table as the Slicer

4. In the matrix, put Attribute in the Columns field, pat value in the Values field.

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

[amitchandak]

@Anonymous , Refer this link

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

[Anonymous]

Hi AmitChandak,

Thanks for you help.

But it works fine for Measure. But how to use is for Columns. I used the same formula but not working.

MainAccount = IF(HASONEFILTER(CodeTest[CodeName]),SWITCH(SELECTEDVALUE(CodeTest[CodeName]),"Code",Accounts[AcctCode],"Name",Accounts[AcctName]),BLANK())

If I select Code        below result should come.

If I select Name      below result should come.

Hope you understand my question.

Thanks

[amitchandak]

@Anonymous , refer Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

Or Try bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive