cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 Team
Community Support Team

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 Team
Community Support Team

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 Team
Community Support Team

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors