Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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
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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |