Forum Discussion

v-power's avatar
v-power
Frequent Visitor
7 years ago

Conditional Formatting not working in Matrix for certain values but works in table

Hello All,   I am facing a weird issue on conditional formatting.   I created a measure to convert my text values to numbers and called it KPINumber. Here is the defintion:   KPINumber = Var...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi v-power ,

 

Based on my test using the Power Bi version : 2.67.5404.341 64-bit (March 2019). I cannot reproduce your issue here. What is your version? Could you please share your pbix to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

 

 

 

Regards,

Frank

v-power's avatar
v-power
Frequent Visitor
7 years ago

Thanks. Unforunately, it does have confidential information. I could see that the reason is because in a table view, the values are not summarized. (I selected the option dont summarize). 

 

However in matrix, its selecting the first of kpi_value and there is no option to do "dont summarize".  If there is an option in matrix , saying dont summarize, then this problem will be resolved.