Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
anusha_2023
Helper II
Helper II

Dynamically update the column header based on the Switch Measure

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

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.

1 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.

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/

View solution in original post

4 REPLIES 4
anusha_2023
Helper II
Helper II

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

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.

Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/

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

lucadelicio
Super User
Super User

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.


Luca D'Elicio

https://www.linkedin.com/in/luca-d-elicio-74a481158/

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.