Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |