07-11-2017 06:41 AM
This quick measure shamelessly steals from Chris Webb's great work that gave us the Star Ratings Quick Measure
In his whitepaper on Dashboard Design Stephen Few recommends avoiding overuse of colour on dashboards.
The best use of colour, he suggests, is for making particular items stand out from the rest.
This quick measure allows you to create red highlighting dots.
First create a 'Flag' measure of your choice, for example:
Flag = if (sum(Sales[Sales])<[Target],1,0)
Then create the Quick Measure as follows:
Alert = REPT(UNICHAR(128308),[Flag])