Forum Discussion

Mani_ms's avatar
Mani_ms
Helper I
5 years ago
Solved

Matrix column names based on slicer selection

Hi , I want to display column name to be based on slicer selection period, i have created two measure using min and max.   Want to change the column header name to be changed as "202101" in place ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Mani_ms 

     

    It is not supported to change measure names dynamically because Power BI uses a definite name to refer to a measure. 

     

    A workaround would be: insert a blank button, set its Button Text with a measure, turn off button's outline, drag this button to cover column header of matrix, group matrix and button.

     

    Text measure is like below. It should be of Text type, otherwise it cannot be selected for the conditional Button Text setting.

    Max Value = CONVERT(MAX('Table'[YearMonth]),STRING)

     

    Reference: Use grouping in Power BI Desktop

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

Mani_ms's avatar
Mani_ms
Helper I
5 years ago

how to add dynamic measure name?

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi Mani_ms 

 

It is not supported to change measure names dynamically because Power BI uses a definite name to refer to a measure. 

 

A workaround would be: insert a blank button, set its Button Text with a measure, turn off button's outline, drag this button to cover column header of matrix, group matrix and button.

 

Text measure is like below. It should be of Text type, otherwise it cannot be selected for the conditional Button Text setting.

Max Value = CONVERT(MAX('Table'[YearMonth]),STRING)

 

Reference: Use grouping in Power BI Desktop

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.