Forum Discussion
Dynamic Field Change
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
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.
4 Replies
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.ThanksAnonymous , refer Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0MOr Try bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
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.
