Dynamic Column Headers in Matrix Filter Selection

[prakash11440278]

Hi Power BI Experts,

I have a requirement to change the column headers dynamically once we change the filters in the report. As part of the workaround i have created cards to display as of now. That is not working when user making some allignements into the report, the layout is disturbing. Please help.

[V-lianl-msft]

Hi @prakash11440278 ,

Not sure how you calculated it.

See if the this thread will helps:https://community.powerbi.com/t5/Desktop/Dynamic-header-in-matrix/m-p/1543605 

If the problem persists,could you share the sample pbix via cloud service like onedrive for business?
Please remove any sensitive data before uploading.

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

[amitchandak]

@prakash11440278 , not very clear. because nothing is shown on screenshots

Two approach bookmarks

or Dynamically change the chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[prakash11440278]

HI @amitchandak ,

Thanks for your reply.

I have a requirement to change the column header names dynamically for the filter selection. In the screen shot i have clearly mentioned that if you switch from one filter to other filter the column headers are changing. Please see the scree shot for your reference. Currently i have implemented static by using card visuals by writing the dax expressions. This is not a suitable approach when the user will select some other actions on the report. layout of the report is disturbing.