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
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • 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
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • 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
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    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: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Color contrast measurements via Power BI report

    Color contrast measurements via Power BI report

    08-13-2020 21:45 PM

    Meagan
    Advocate V
    3581 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Meagan
    Meagan Advocate V
    Advocate V
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Color contrast measurements via Power BI report

    ‎08-13-2020 09:45 PM

    Color contrast can make your report focused, interesting, and accessible, if you use it correctly. This report advises you how to use two colors together in a report based upon WCAG 2.1 standards. For example, you can use two colors that have a contrast ratio of 3:1 for non-text chart components, but you should look for colors with a 4.5:1 color contrast for text. Enter colors from your last report, or from a Power BI theme to find out if they can be used in an inclusive design. 

     

    The report dataset was created entirely in Power Query by doing some color math. It uses a table of values from 1 to 255 to generate the 16 million possible colors, then converts the RGB value to Hex. It then linearizes the color values and calculates luminance. From there, the color contrast ratio is dynamically calculated in DAX as you enter new hex color values. 

    eyJrIjoiMWQxOTIxZmMtMWZjZS00MDFhLWJhMDUtMzkyYTUzNjZhMTM1IiwidCI6IjU0YTc3ZTU4LTliZjktNDc1OC05M2M3LTk0Y2ZkNmYwNTY3YSIsImMiOjZ9&pageName=ReportSection

    Labels:
    • Labels:
    • Other
    Message 1 of 2
    3,581 Views
    4
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    cabc_xlorla
    cabc_xlorla Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-14-2020 09:01 AM

    @Meagan .  this is exemplary, voilà.

    hiclipart.com.png
    Very intesting use of Power Query to get the values.

    What I loved most, was the relationship between Math and Colors. (luminance calculation).

    Well done. I am going to keep this link or post handy for my reporting design from now on.

     

    Message 2 of 2
    3,513 Views
    2
    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
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices