sql server - Chart line title in SSRS -


i'm working on ssrs line charts. in single graph have 4 lines, each 2 of comparisions. woud add title each line in chart below. understand data without checking color code of each lines axes definitions located @ end of chart. please guide me how achieve it. enter image description here

update: please find requirement question below in excel. similar in ssrs

https://superuser.com/questions/807068/how-to-display-series-name-inside-bars-of-stacked-bar-chart

you can set label property of series show helper text conditionally specific x-axis value.

click serie need label, in case [sum(cancelations)] can see in below screenshot.

enter image description here

press f4, properties window appear. in property window, search label node , expand it, this:

enter image description here

in label property have use expression determine have place label, in case i've used:

=iif(fields!day.value="123", "cancelation", nothing ) 

this expression says, show cancelation label when x-axis label equal 123, if day field (x-axis) not 123 shows nothing.

the same logic if want label appearing @ beginning of line, in case have use first value in x-axis.

=iif(fields!day.value="2", "t-2", nothing ) 

it says if day.value equal 2 show t-2 label. otherwise show nothing.

i've created example.

enter image description here

alternatively, can use tooltips if generating report in interactive format mhtml. note tooltip appears when pass mouse on line.

note have set visible property true pointed in screenshot.

let me know if helps.


Comments

Popular posts from this blog

javascript - Thinglink image not visible until browser resize -

firebird - Error "invalid transaction handle (expecting explicit transaction start)" executing script from Delphi -

mongodb - How to keep track of users making Stripe Payments -