Highlight Value if Value is Less then previous date in matrix

[shahbaznawaz37]

I am new to Power BI I want to highlight the value in matrix visual if its less then pervious date value. for example, Van_no 0016 & 1005 have less mileage on 08-Apr-20 as compare to 07-Apr-20 and the same condition is for 06-Apr-20 vs 07-Apr-20 also.

thanks in advance.

[v-diye-msft]

Hi @shahbaznawaz37 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly.thanks!

[shahbaznawaz37]

Dear All,

Not found any solution from the community I tried a lot but failed.

Total Mi flag =

VAR vMeasure = [Total Mi]

VAR vDate = MAX(daily_delivery_report[ddr_date])

VAR vPrevious = CALCULATE([Total Mi],FILTER(daily_delivery_report,(vDate - 1)))

RETURN

IF(vMeasure < vPrevious,1,0)

Above formula is showing everywhere 0 

 

[Greg_Deckler]

You probably want to create a flag measure like:

Flag Measure = 

  VAR __Measure = [Current Measure]

  VAR __Date = MAX('Table'[Date])

  VAR __Previous = CALCULATE([Current Measure],FILTER('Table',(__Date - 1)))

RETURN

  IF(__Measure < __Previous,1,0)

[shahbaznawaz37]

can you please correct below because I am unable to put the column name without function.

Flag Measure =

VAR __Measure = MAX(daily_delivery_report[mileage_in])

VAR __Date = MAX(daily_delivery_report[ddr_date])

VAR __Previous = CALCULATE(MAX(daily_delivery_report[mileage_in]),FILTER(daily_delivery_report,(__Date - 1)))

RETURN

IF(__Measure < __Previous,1,0)