Now i want to show if (Margin%)<90% ,Blue color till 90,after 90 to 100 other color ,similary 4 Colors in Single bar .
How to achieve this.any help would be greatly appreciated.
Plz find the attached report screen.
Thanks for your time,i used same but if value for Q1 is 150, its >90 so till end bar showing single color.
i want till 90 one color ,90 to 100 one color .....
if you want it exactly the colors of the picture you posted:
if (Margin <= 90, Blue(),
if(Margin > 90 and Margin <=95, lightGray(),
if (Margin >95 and Margin < 100, Yellow(), Green ()
Create a Synthetic Dimension for <90, 90-100,>100
Modify your measure to show these Values
Use Pick(wildmatch(Valuelist('<90', '90-100','>100'),'<90', '90-100','>100'),
Try this way.. It might help