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 everyone, I am facing an unusual issue in applying conditional formatting for column chart. I have attached below the images for your reference.
This is the column chart I have created
And this is the rules I have given
Thank you all .
@amitchandak @Ashish_Mathur @FreemanZ please help
Solved! Go to Solution.
hi @prv_1401
0.13 is orange, because 0.13 > 0.26*20%
in the conditional format rule setting, 100% is not 1, but 100% of the max value, which is 0.26 in your case.
@FreemanZ Thanks man. I am getting it .... so what is the alternative solution to resolve this ?
So it's manually entered data.
hi @prv_1401
0.13 is orange, because 0.13 > 0.26*20%
in the conditional format rule setting, 100% is not 1, but 100% of the max value, which is 0.26 in your case.
When I keep the data type as whole number. The columns are not shown and when checked on data pane the values are changed to 0% for all weeks.
is bLOCKEDI a measure?
Could you check the data type AND format of bLOCKEDI? Let me know if it's on Whole number and Percentage. Thanks!
Its Decimal number and percentage
p.s you can check this by clicking on the column in the right hand side "fields" pane then look at the top ribbon in "Column tools".
It should tell you both the format and data type there 🙂
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 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |