Creating a horizontal/constant line in line chart using just one single number which changes daily

[Anonymous]

Hi all,

I have a data model consisting of one long fact table with different time series in it. I have one smaller dimension table which also includes some descriptive statistics for every time series. There is a relationship between both tables. 

The descriptive statistics in the dimension table are updated on a daily basis. I want to see some of these descriptive statistics in my line chart containing the time series of the fact table. For example: for one time series I want to add horizontal lines of the mean, mean plus standard deivation, mean minus standard deviation etc. These horizontal lines must be created from these single numbers. 

So to summarize: plot this descriptive statistic, which is just a single number in the dimension table, on the whole line chart. 

A possiblity would be to include a whole column with the same number in the fact table but this will result in performance issues.

[lbendlin]

You can either have a legend or multiple values but not both.

[Anonymous]

Ah that is unfortunate but thank you for your answer. 

[lbendlin · Accepted solution]

create measures that produce these constant values, and then add the measures to your line chart visual.

[Anonymous]

How do I add a measure to my line chart visual? As the axis, legend and values fields are already filled with other data