How to do conditional Formatting on numbers to percentage

[Gopal_PV]

Hi Folks,

i am having coloumn booking days which iam calculating between two dates.  Now i want to conditional formate this days based on percentage. my requirement is now i want to do conditional formate numbers measure but need to percentage.

if Booking id 1 user need to see by his individual percentage wise. Not numbers wise.

 i tried to apply bur not able to achive.

if Booksdays >=20% <50% Red color

if Booksdays >=51% <75% Yellow color

if Booksdays >=76% <80% Green color

if Booksdays >=81% <120% Blue color

Booking ID	Booking Days Measure
1	10
2	20
3	25
4	27
6	30
7	100
8	200
9	600

[Anonymous · Accepted solution]

Hi @Gopal_PV ,

Below is my table:

The following DAX might work for you:

Column = 'Table'[Booking Days] / SUM('Table'[Booking Days])
Column 2 = 
   SWITCH(
     TRUE(),
      'Table'[Column] <= 0.2 , "green",
     'Table'[Column] > 0.2 && 'Table'[Column] <= 0.35 , "yellow",
     'Table'[Column] > 0.35 , "red"
   )

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

What are you basing the percentage on? Assuming for Booking ID 1, 10 is the numerator - what is the denominator to calculate the percentage you want to conditionally format on?

[Gopal_PV]

Hi   

IF <= Average +20%, "Green", 

IF > Average + 20% && <= Average + 35%, "Yellow", 

IF > Average + 35%, "Red"