Forum Discussion

BiDesign's avatar
BiDesign
New Member
2 years ago
Solved

Conditional formatting not working after using calculation group authoring

Hi all,   I recently set up a calculation group using the Calculation group authoring preview feature.  Unfortunately, since doing this I've not been able to set any conditional formatting based on...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  BiDesign ,

     

    As far as I know,  I can select it normally when the measure and calculation columns used for conditional formatting are in text format .

     

    Measure =
    IF(
        MAX('Table'[Value])>=4,"red","blue")

     

     

    When the measure and calculation columns used for conditional formatting are in number or date format, nothing can be selected.

     

    Measure =
    IF(
        MAX('Table'[Value])>=4,1,0)

     

    You can change the result to Text format, the Format() function does.

    FORMAT function (DAX) - DAX | Microsoft Learn

     

    Here are the restrictions associated with Conditional:

    Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.