Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

new matrix - data bar not available for calculated value

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

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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