cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trdoan Member
Member

Invert/Reverse Trend Chart?

Hello everyone,

 

Is there a way to reverse the chart below so the line is trending downward? Here is the link to the pbi file.

 

Capture.JPG

 

Can anyone please advise if it is possible to reverse the trend line? Thanks a lot!!! 

 

 

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Invert/Reverse Trend Chart?

@trdoan ,

 

Click the ellipse on the right-top hand of line chart, then click "sort descending".

Capture.PNG 

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.

Highlighted
trdoan Member
Member

Re: Invert/Reverse Trend Chart?

Hi @v-yuta-msft , thanks for your advice but it isn't quite what I was expecting.

 

It does trend downward, however, the start month is February 2019 and goes backward to 2018, which is a bit confusing for anyone trying to mull over how this chart works.

 

I don't know if this piece of information is important but this Turn-around-time chart has this sort of logic: my firm considers an increase in TAT a bad impact on the business and from the chart you can see all numbers are negative and starting from May 2018, it keeps increasing (negative numbers getting closer to 0), which is obviously not a good trend, bad at the very least.

 

Is there a DAX expression that is able to ignore the negative sign during the computation (which I think is easier to set the chart to trend downward) but still can show the negative sign in the chart?

 

Apologise if all of this logic confuses you. Let me know if this is possible and if you have any suggestion how to go about this. Thanks a lot!!!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,023 guests
Please welcome our newest community members: