new matrix - data bar not available for calculated value

[Anonymous]

I don't see the "conditional format" option for values field that i put under matrix table. This field is a calculated measure created from dax. Is it possible to do conditional format or data bar for it?

Also, is it possible to sort the matrix table by data value (calculated measure)?

Thanks,

Wenchi Wang

[v-sihou-msft]

@Anonymous

Does your measure return numeric value?

As I tested, the "Conditional Formatting" is available in Matrix for calculated measure.

To sort the matrix, you can only click on the column header.

Regards,

[Anonymous]

Thanks, I did have my measure format as percent, this is why is not available for conditional format.

As for sorting, I have date dimension on the column and product dimension on the row and quantity as value in the matrix table. I don't think there is option to sort the value based on any column header, correct?

Wenchi