Enable Dynamic Column Headers in Matrix Visual (Context-Aware Labels)

Hi Haroldhngn, 

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thank to Poojara_D12, lbendlin, for those inputs on this thread.

You are on the right track, but the limitation here is with the Matrix visual in Power BI, as column headers can only come from columns, not measures, so your DAX won’t dynamically replace “Curr.” / “Prev.” even if it returns correct values. You can improve stability by using SELECTEDVALUE(StaticMeasureMapping[ShortName]), but to achieve dynamic month names (like “Mar 2023”, “Feb 2023”), you will need to move this logic into a column based approach (e.g., a disconnected table with offsets and a derived month label used in Matrix columns), while advanced options like calculation groups can help further, currently measure-driven headers aren’t supported, so you may consider voting for this feature here: https://ideas.fabric.microsoft.com 

Refer tothese docs for guidance: 
1.Create a Matrix Visual in Power BI - Power BI | Microsoft Learn
2.Use report readers to change visuals - Power BI | Microsoft Learn
3.Calculation groups in Analysis Services tabular models | Microsoft Learn

Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.