Dynamic Header column names in table

[homelander123]

I have a column in my data which is Lookup. 

I have created a table which shows Lookup in the Header however i want it to dynamically change to invoice id/Epenseid etc based on whatever is selected in the Name slicer. 

BTW The "Name" is another column in the data and table for which i have created a slicer as well

[Anonymous · Accepted solution]

Hi @homelander123 ,

I’d like to acknowledge the valuable input provided by lbendlin.  Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

1. Create a new field parameter in the modelling box.

2. Select the field you want to add.

3. Place the parameter in the table.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[lbendlin]

Please read about Field Parameters.

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