PBI Desktop KPI Visual (Dates Reversed)

[MarkCBB]

Hi There,

I have the Below DB:

I created the Below Measure:

KPI Core OOS = DIVIDE(				CALCULATE(COUNTROWS(SALES);SALES[SALES RANKING]="CORE";SALES[SOH] <=0);
					CALCULATE(COUNTROWS(SALES);SALES[SALES RANKING] = "CORE")
					;0)

However When I add that measure into a KPI Visual, the dates are displayed in reverse, and I have no idea why this is happening.

 

[Matt Allington]

What do you mean "dates are reversed"? This measure returns a decimal number, right? What does that have to do with dates?

 

[MarkCBB]

Hello Matt,
the
The Visual called KPI (https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-kpi/), uses dates to determine the end result and obviously the trend (Very cool visual), I managed to get the dates to flow correctly, I am not 100% sure how I was able to fix it as I just kept trying different things but I was able to solve it and for some reason I am not able to reproduce it again, (Driving me crazy). but all sorted now - Thank you.

 

[Matt Allington]

Ah yes, sorry - I knew that. I think I have heard of issues with columns sorted based on another column. What was your problem and solution?

 

[MarkCBB]

ahhh, It was exactly that, sorted a column, that is also why I couldn't figure out what I changed to get it to work, I re call deleting a table and re adding it and obviously didn't do the sorting the 2nd time