If you drop the measure that you want to color by onto your color shelf you can color either as a continuous measure (in which you'll get a color scale) or as a discrete measure in which each value gets it own distinct color.
Let me know if you have any questions.
If i put into colour shelf means we can assign various colours.But i want to put those colours permanent as a condition for future data also.
I am having three different softwares i want to track those softwares running time
Software 1 - 03:00:00
Software 2- 09:00:50
Software 3- 04:00:00
Here i want to track in which software taking above 8 hours means it should show as red in colour,Software which is in between 4-8 hours should show green in colour,Software which is below 3 hours means it should shows green in colour?
Are you clear with my question?
It will be easier for people to provide a solution if you could share a sample workbook.
If you want to color based on ranges within the running time field then you can create a calculated field like this (replace the name of the running time field with whatever it's actually called). Also, did you mean to have both the 4-8 hour range and below 3 hour range as green? I believe you want the 4-8 hour range to be yellow, but if not, you can adjust that as well.
if sum([running time]) > 8 then "Red"
elseif sum([running time]) > 4 then "Yellow"
Drag that onto your color mark and adjust the colors so that "Red" is red, "Yellow" is yellow, and "Green" is green.