Forum Discussion
Conditional formatting not working after using calculation group authoring
- Anonymous2 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.
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.