topic Re: Dynamically change column name in DAX Commands and Tips

Dynamically change column name

homelander123 — Wed, 02 Oct 2024 17:13:26 GMT

I have created a table with a column being lookup which is coming from the data. However, i want the column name to be dynamic instead of showing lookup.

E.g if in the filters i have selected invoice number i want the name to be invoice id

if in the filters i have selected expense it should be expense id

Re: Dynamically change column name

lbendlin — Wed, 02 Oct 2024 21:40:32 GMT

Please read about Field Parameters

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Re: Dynamically change column name

dharmendars007 — Thu, 03 Oct 2024 07:00:35 GMT

Hello homelander123 ,

You have to use Filed Parameters in combination with SelectedValue() Measure to get your logic working..

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

Re: Dynamically change column name

Anonymous — Fri, 04 Oct 2024 05:35:26 GMT

Hi homelander123

Did lbendlin 's and dharmendars007's methods solve your problem? If yes, could you please mark them as solutions? This will help more users who are facing the same or similar difficulties. Thank you!

If "invoice number" and "expense" are in the same column, I'm afraid PowerBI can't achieve this effect so far. But I think your idea makes sense. I found an idea that meets similar needs as yours, and you can vote for it to help make it happen as soon as possible.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=ce2cffa2-147c-ef11-a4e6-000d3ae47b7b

Hopefully this will be possible in a future release.

If you still have questions, please feel free to ask me.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.