Dynamic chart title based on slicer selection

[Anonymous]

Hi,

We have a line chart in our dashboard based on product sales.  We have placed a slicer based on which this line chart diplays the product sales.  We would like to have a dynamic chart title which will be based on the slicer selection.  kindly advise how we can make this happen

regards,

dsmitha

[TomMartens · Accepted solution]

Hey @Anonymous ,

you can create a measure like so:

vizAid Seleceted Colornames as String = 
CONCATENATEX(
    VALUES( 'DimProduct'[ColorName] )
    , 'DimProduct'[ColorName]
    , ", "
)

Then you can assign this measure as dynamic title to the chart:

The result:

Hopefully, this provides what you are looking for.

Regards,

Tom

[Anonymous]

Hi TomMartens,

Thank you very much for your quick response, this is what we aere looking for 

double kudoz

regards,

dsmitha