Stephen Few 'Red Dot' 08-04-2020 08:13 AM

[theBIbutler]

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])

eyJrIjoiNDkyZGNlNTItOGZhYy00N2M0LWIyYjEtYmYxNTJlYTBlOGI0IiwidCI6IjlkMzQ4NzUyLWI5YWMtNGI1OS1iY2YzLTgwMTQxMjZlMDExNyIsImMiOjh9

[nirrobi]

great !!!
Can you please elaborate regarding spark line

I wish to acheive something like the one below

[michaelsh]

Hi @nirrobi 

I understand you're trying to create  dashboards that look like Stephen Few's design.  I'm trying to achieve this myself too

But didn't find an option to create spark lines or bullet charts in matrixes. 
Have you made any progress?

Would you mind share some of your achievements?

Thanks a lot!

[theBIbutler]

Hi,

You can do it by layering different visuals, it's just a bit fiddly to get things lined and spaced correctly but it is possible to get creative to accomplish something like what you want....

 Cheers

Mark