topic Re: How to create dynamic header in Report Server

How to create dynamic header

Anonymous — Mon, 01 Feb 2021 12:48:41 GMT

Hello there,

I hope everyone is fine.

I need some urgent help as per my customer needs.

Does someone know how to create dynamic header in Power BI report server desktop?

I have a table with different month columns of the previous year and the current year. So in my current table previous_01 is Jan 2020 and Current_01 is Jan 2021 and so on.

What my customer wants that column should be dynamic and not static. So if we refresh data next year, the column name Previous_01 should change into Jan 2021 and not Jan 2020. Similarly, for column name Current_01 should change into Jan 2022 and not Jan 2021. Any idea how to achieve this?

Many thanks in advance for your support 🙂

Regards,

Ankit Parihar

Re: How to create dynamic header

Greg_Deckler — Mon, 01 Feb 2021 14:43:14 GMT

@Anonymous No real clean way to do this. Perhapsa Card visualization that you layer over top of the column header name. You would create a measure to return the desired text and use that in the Card visualization.

Re: How to create dynamic header

josef78 — Mon, 01 Feb 2021 16:36:28 GMT

Use dynamic column names is not problem (you can use dynamic parameter in rename function), but how you will manage in visualisation?

Another idea, use unpivot function, to transform from columns to rows. Transoform atributes as you want, and add sort column. And in visualisation use pivot table to show as you want (in columns, dynamicaly, and in correct order)

Re: How to create dynamic header

Anonymous — Tue, 02 Feb 2021 09:01:51 GMT

Thanks for the reply Greg. Could you explain me with an example?

Re: How to create dynamic header

Anonymous — Wed, 03 Feb 2021 02:08:26 GMT

@Anonymous

I had the same question before with my research and test, I am pretty sure currently power bi do not have dynamic header feature, as @josef78 mentioned, there are ways to make it very close to your requirement but in the actual report you cannot make it with a clean method.

Best Regards
Paul Zheng

Re: How to create dynamic header

KBO — Fri, 05 Feb 2021 07:41:14 GMT

@josef78 ,

did you mean changing header If you choose a filter? Thats a really easy thing to do 🙂 -> https://www.youtube.com/watch?v=TYLKDPcvgK8

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: How to create dynamic header

josef78 — Fri, 05 Feb 2021 20:50:51 GMT

I'm not sure what @Anonymous need to see, but I think it is not about dynamic title, but about dynamic header in table.

I'm think it is not problem, dynamic header in Power BI is supported is supported, it is well know feature, it is "pivot table".

But for pivot table you need prepared data, and you can easy use unpivot function in power query part.