skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Quick Measures Gallery
    • Re: Stephen Few 'Red Dot'

    Re: Stephen Few 'Red Dot'

    08-04-2020 08:13 AM

    theBIbutler
    Resolver II
    9231 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    theBIbutler
    theBIbutler Resolver II
    Resolver II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Stephen Few 'Red Dot'

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

    eyJrIjoiNDkyZGNlNTItOGZhYy00N2M0LWIyYjEtYmYxNTJlYTBlOGI0IiwidCI6IjlkMzQ4NzUyLWI5YWMtNGI1OS1iY2YzLTgwMTQxMjZlMDExNyIsImMiOjh9

    Preview file
    12 KB
    Stephen Few Red Dot.pbix
    Labels:
    • Labels:
    • Other
    Message 1 of 4
    18,398 Views
    16
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    nirrobi
    nirrobi Helper V
    Helper V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-30-2019 10:09 AM

    great !!!
    Can you please elaborate regarding spark line

    I wish to acheive something like the one below

     

    dashboard.jpg

     

    Message 2 of 4
    12,626 Views
    0
    Reply
    michaelsh
    michaelsh Continued Contributor
    Continued Contributor
    In response to nirrobi
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-31-2020 08:40 AM

    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!

    Message 3 of 4
    9,369 Views
    0
    Reply
    theBIbutler
    theBIbutler Resolver II
    Resolver II
    In response to michaelsh
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-04-2020 08:13 AM

    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....

     

    Stephen Few Design.jpg

     Cheers

     

    Mark

    Message 4 of 4
    9,231 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices