Enable Dynamic Column Headers in Matrix Visual (Context-Aware Labels)
Hello Power BI Team, I would like to suggest a new feature for the Matrix visual in Power BI: the ability to use dynamic column headers that reflect the current context, such as displaying actual month names instead of static labels like "Curr." or "Prev.". Current Limitation: - Matrix columns can only use static field names or values from a table. - DAX measures cannot be used as column headers, so it is not possible to dynamically display contextual labels (e.g., "Mar 2023" for "Curr.", "Feb 2023" for "Prev.") that change with slicer or filter interaction. Proposed Feature: - Allow the Matrix visual to use DAX measures or expressions as column (and/or row) headers. - Enable column headers to update dynamically based on context, such as current period selection, previous period, or other slicer/filter values. This would greatly enhance the clarity and flexibility of time-based and comparative reporting. Example Use Case: In a financial or risk report, instead of generic "Curr." and "Prev." columns, the Matrix would automatically show "Mar 2023" and "Feb 2023" as headers, reflecting the periods being compared. This reduces user confusion and makes reports more intuitive, especially when using time slicers. If this capability already exists or there are recommended workarounds, I would appreciate any guidance. Otherwise, I believe this enhancement would add significant value to Power BI reporting. Thank you for considering this suggestion!