Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to modify expression for display company value label ?

Hi All   Below blog post about " Dynamic Chart Title " https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/   it have mentioned about below expression :-   Title = "Sales...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous -

     

    Create a measure as below 

    Title =
    "Sales for "
    & CONCATENATEX (
    VALUES ( SALES[COMPANY] ),
    SALES[COMPANY],
    ", "
    )
  • themistoklis's avatar
    themistoklis
    5 years ago

    Anonymous 

     

    Create the following measure and add it to the formula on title section

    Measure = "SALES FOR " & SELECTEDVALUE(SALES[COMPANY])

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous -

 

Create a measure as below 

Title =
"Sales for "
& CONCATENATEX (
VALUES ( SALES[COMPANY] ),
SALES[COMPANY],
", "
)