Forum Discussion
Dynamic chart title based on slicer selection
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
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
2 Replies
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