Forum Discussion

AvPowerBI's avatar
AvPowerBI
Post Patron
4 years ago

Dynamically change column header

Hi,

 

Is it possible to have the column header on a Table or Matrix Visualization to change its name if a filter is applied?

 

So if the Field Invoiced is set to "N" then I want the Column header label to show Days Old, if it is set "Y" then I want the Column header label to show Days to Deliver

 

Thanks

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    AvPowerBI , I doubt you can change column name/header.

    But can change visual title based on measure. So you can disply information in title, using a measure 

     

    Measure  = "Days Old " & selectedvalue(Table[Column])

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI AvPowerBI ,

     

    Yes it is possible by creating a measure using the values from a slicer and using this measure as a dynamic title of the visual.

    You haven't given me anything on your data like what your data looks like.

    If you see the small video below, my visual title is changing based on the selection from my slicer on the right.

    I created a simple measure as follows:

    Conditional Title = 
VAR prodName = VALUES('Supermarket Sales'[Product line])
VAR occur = COUNTROWS(ALL('Supermarket Sales'[Product line])) = COUNTROWS(prodName)
RETURN
IF(
    occur, "Summary of Products",
    CONCATENATE("Summary of Product Line: ",
        CONCATENATEX(
            prodName,
            'Supermarket Sales'[Product line], 
            ", "
        )
    )
)

    The used this measure in the title area of the visual by clicking on the "fx" sign:

    This opens a new window to select the meausre that is created above to dynamically change the title of the visual:

     

    Thanks,

    Pragati