cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
commodity_check
Helper II
Helper II

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

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.

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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

View solution in original post

4 REPLIES 4
lbendlin
Super User III
Super User III

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

Ah that is unfortunate but thank you for your answer. 

lbendlin
Super User III
Super User III

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

View solution in original post

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors