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.
Hi,
Created a simple Conditional Formatting rule, but sometimes value 1 shows Yellow which is incorrect, according to the rule value 1 shuld be Green always, where could be the problem? I posted like 14 decimal places but is still 1.
Thanks
hi @Vitalijus
If you change the data type from decimal number to Fixed decimal number and try it again.
and if you still have the problem, please share your sample pbix file for us have a test.
Regards,
Lin
Agreed with Pragati11, check the data types. Is there DAX doing the calculation? If not, try coding the DAX one of three ways:
Hi @Vitalijus ,
Are values in "AQ+Orders / Forecast" decimal type?
They look like they are not. I see a comma in them rather than a dot which is for decimal numbers.
Check datatype of your column.
Thanks,
Pragati
@Vitalijus , Try this, if it can work. Create a rounded 2 or 3 decimal place number and have conditional formatting on that.
Also, log and check issue at :
https://community.powerbi.com/t5/Issues/idb-p/Issues
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |