How do we achieve the thresholds like below. If east above 50 % it will be red color and same like with others. how we will get? thanks in advance
You can use a conditional formatting.
Create a calculated field
IF SUM([XXX])<XX THEN "Red" ELSE " Green" END
Drag this measure on to colour shelf.
Please let me know if this helps
Retrieving data ...