Dynamically update the column header based on the Switch Measure

[anusha_2023]

I have a Switch measure added to the Value section of the matrix with the below columns which are measures.

Forecast Measure =

SWITCH(

    TRUE(),

    [Forecast 3] > 0, [Total Forecast3 coalses],

    [Forecast 2] > 0, [Total Forecast2 coalses],

    [Total Forecast1 coalses]

    )

For the Forecast Measure, I want to update the header Forecast Measure as Forecast1 or Forecast2, or Forecast 3 based on the selected Switch measure. Can anyone help me how to achieve this by dynamically updating the column header name based on the measure.

[anusha_2023]

I could not find a solution to dynamically update the column name. Could anyone have an idea on my problem statement.

[lucadelicio · Accepted solution]

I think is not possible on PowerBi to change the column name header dinamically.
The only way is to use different measure with parameter as i show before.

Otherwise you can change dinamically the title of the visual with a measure that retuns the text that you want.

[anusha_2023]

Thanks for the suggestion. I managed with the text box.

[lucadelicio]

Hi @anusha_2023 ,

try yo look at this project as attachments with field parameter you can change the measure that you need for the column of a table. Also the title will change.