cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Showing relative change in line chart

Hi,

 

I have a dataset with around 80 testvalues each day, and I want to plot each of them separately in a line graph to see the development. This I have achieved with a filtering.

In this line graph I also want to show the allowable relative change (both upper and lower, say +/- 5%), from day to day as two other lines. The idea is for me to be able to see when the testvalue changes too much. Therefore I want the relative change line to be shifted so it shows in relation to the datapoint of the previous day. Is there a way to do this?

Something like below, but without the circles and the gridlines.

Capture.PNG

I have a testID for each testvalue, as well as a field called testdate with the date.

 

Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Showing relative change in line chart

@Anonymous ,

 

You can use DAX function like

 

PREVIOUSDAY(<dates>)  

https://docs.microsoft.com/en-us/dax/previousday-function-dax

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: Showing relative change in line chart

@Anonymous ,

 

In general, you can create an additional measure or calculate column and then drag it to the value field. 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Re: Showing relative change in line chart

Thank you!

 

I have tried that, but I can't seem to get it to relate to the previous day, only today.

Do you have tips to how I can do this?

Community Support
Community Support

Re: Showing relative change in line chart

@Anonymous ,

 

You can use DAX function like

 

PREVIOUSDAY(<dates>)  

https://docs.microsoft.com/en-us/dax/previousday-function-dax

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

Top Solution Authors
Top Kudoed Authors