Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
prv_1401
Helper I
Helper I

Conditional formatting for column chart is not working properly

Hi everyone,  I am facing an unusual issue in applying conditional formatting for column chart. I have attached below the images for your reference. 

tmp_09648f99-0c78-474c-bb17-c857a48db07e.png

 This is the column chart I have created 

tmp_d47925b8-80cb-4823-8706-d3ae23de295f.png

 And this is the rules I have given 

  

tmp_90d6a091-cd12-4677-8882-caa4628078a6.png

  •  This is the outcome I get. But as per the rules wk 12 and wk13 shud be orange. Please enlighten me on this like why does this happen. 

    Thank you all .

     

    @amitchandak @Ashish_Mathur @FreemanZ please help

     

     

     

1 ACCEPTED 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. 

View solution in original post

9 REPLIES 9
prv_1401
Helper I
Helper I

@FreemanZ  Thanks man. I am getting it .... so what is the alternative solution to resolve this ?

hi @prv_1401 

you can choose number. the dividing point is up to your expectation. 

FreemanZ_0-1675919828533.png

 

prv_1401
Helper I
Helper I

  • No. I manually entered data in format like 0.05 so when I convert to percentage it is 5%. 
  • tmp_d1a4fb88-906e-41c5-a169-be7fce34ebf8.png

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. 

prv_1401
Helper I
Helper I

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?

ADPowerBI1
Responsive Resident
Responsive Resident

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 🙂 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors