Conditional formatting with parameter value not working

[jsbourni]

Hi,

I had a working conditional formatting based on the selected value of a parameter. For unknown reasons, it's not working anymore. Here's the DAX:

Measure
Delay = 
CALCULATE(
    DATEDIFF(
        MAX(students[date]), TODAY(), DAY)
        )

Parameter
Threshold (days) = GENERATESERIES(0, 500, 5)

Cond. formatting measure
Delay color flag = 
IF(SELECTEDEVALUE(Threshold (days)) < [Delay], "#ff0000","#66ff33")

In the table, cells are all red not matter the parameter's value. Both fields (Delay and parameter) are integers. As I mentioned, it was working. Could it be a version issue?

Thanks

[Anonymous]

Hi, @jsbourni 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

not working where? In the Desktop or in the service?  When did it stop working?

[jsbourni]

Hi, 

Desktop version. Can't tell if it's 2-3 weeks or more as I just saw that (instead of being reported by users...). We made some minor changes in the table behind but nothing that would have affected these specific values.

Thanks

[lbendlin]

Can you pick a potential culprit from the list?

[jsbourni]

Hard to tell. If I had to guess I would go for the last one (2.135.7627.0), but who knows. Do you have those up to June? If nobody saw it until now, it is more than likely that it was not consulted at all during summer, so it could come from a previous version. Thanks.

[lbendlin]

[jsbourni]

Can't find an issue directly related to mine in the list. Not a specialist though.Thanks