Seeking Alternatives for Creating a Dynamic Header for Matrix Visual in Power BI

[digicontrolling]

Hello Power BI Community,

I'm working on a report where I need to create a dynamic header for a matrix visual. I have a slicer that allows users to compare values against either the Budget or the Previous Year, and I want the header of the matrix to dynamically reflect the current comparison.

I'm aware of the method that involves creating a dynamic measure and using a card visual to display the header text based on the slicer selection. And, I'm also aware of the bookmark solution using two tables. However, I'm looking for an alternative solution that might be more integrated with the matrix visual itself.

Has anyone encountered this issue before or have any alternative suggestions on how to create a dynamic header that changes based on slicer selection? Your insights and experiences would be greatly appreciated!

Thank you!

digicontrolling

[digicontrolling]

Thanks , @Idrissshatila this does the job.. 🙂

[Idrissshatila · Accepted solution]

Hello @digicontrolling ,

Yes, you could use field parameters, check it out here https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡