Forum Discussion

jsbourni's avatar
jsbourni
Helper II
1 year ago

Conditional formatting with parameter value not working

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

Need Help
Tips and Tricks

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

     

     

    • jsbourni's avatar
      jsbourni
      Helper II
      1 year ago

      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's avatar
        lbendlin
        Super User
        1 year ago

        Can you pick a potential culprit from the list?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.