Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to add dynamic text to a chart title when a user selects more than one value in a list box i.e. if a user selects three regions in a list box how do I display all three regions in the chart title?
Thanks
Hi Greg, put this expression into Title property of the chart (open chart properties with it's context menu):
='Regions: ' & Concat( DISTINCT [Region], ', ' )
Please mark the answer as correct and your question as answered if it helped.
Hi Greg, put this expression into Title property of the chart (open chart properties with it's context menu):
='Regions: ' & Concat( DISTINCT [Region], ', ' )
Please mark the answer as correct and your question as answered if it helped.
Try adding this to the chart title:
=concat(Distinct YourDimension,', ')
Regards,
Gabriel
Thanks Vasily. That worked. But is there a way to get the list of regions to span more than one line in the chart. It is trying to list them all on one line and there isn't enough room.
Greg
Go to your sheet appearance and title section then add this expression manually
='Selected Region: ' & Concat(Distinct [Region Dimension],',')
You can try this:
='Regions: ' & Concat( DISTINCT [Region], Chr(10))
I just added a return as follows and it put each region on a separate line -
='Regions: ' & Concat( DISTINCT [Region], ',
' )
Sure that is an option as well