Forum Discussion

jrecasens's avatar
jrecasens
Advocate I
9 years ago
Solved

Conditional formatting in CALCULATED tables

Just realized that column conditional formatting is not working with tables created by CALCULATETABLE Function (DAX), please fix.
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi jrecasens,

     

    Conditional Formatting is available when the column specified with any aggregate function or it's a measure. In your scenario, you can set one aggregate function for the Amount column, eg: Sum. Then you can see the Conditional Formatting is available. Please see attached .pbix file.

     

     

    By the way, as Apple contains blank value, if you want to make it display. You can enable Show items with no data option for Product Name.

     

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi jrecasens,

 

Conditional Formatting is available when the column specified with any aggregate function or it's a measure. In your scenario, you can set one aggregate function for the Amount column, eg: Sum. Then you can see the Conditional Formatting is available. Please see attached .pbix file.

 

 

By the way, as Apple contains blank value, if you want to make it display. You can enable Show items with no data option for Product Name.

 

 

Best Regards,
Qiuyun Yu

jrecasens's avatar
jrecasens
Advocate I
9 years ago

Excellent, adding an aggregate function to that specific column I need the conditional formatting works.