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
    • Office 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
    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
    • Data Stories Gallery
    • Quick Measures!

    Quick Measures!

    02-09-2019 21:01 PM - last edited 02-09-2019 21:05 PM

    Super User Greg_Deckler
    Super User
    1590 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    Greg_Deckler
    Super User Greg_Deckler
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Quick Measures!

    ‎02-09-2019 09:01 PM

    This data story is a bit of a labor of love. I love, love, love the Quick Measures Gallery. It's one of those things I latched on to because I found myself answering what amounted to be the same question over and over again in the forums. So, I reasoned it was far better to solve the problem once, post it to the Quick Measures Gallery and reference it versus reinventing the wheel each time. So that's exactly what I do these days.

     

    But, even though I love the Quick Measures Gallery, it is not without its flaws. The user interface for it isn't particularly, well, "pretty". It lacks a number of features like search capabilities and is limited on the slicing and dicing that can be done. So, I figured, why not use Power BI to collect the data and build some spiffy reports that might make things easier to find!

     

    This Data Story makes heavy use of the "Web by Example" feature. I started several queries this way and then turned them into functions in order to collect information on each quick measure and each author. To see how I did it, check out my blog article "Turning 'Web by Example' into Power Query Functions". I also spent some time implementing report page tool tips and adding little embellishments like a little drill icon that denotes the ability to use drillthrough on that particular visual. One can drillthrough from either the Analytics or Author pages to the Details page and the Details page has links directly to the quick measure in the Community site as well the URL to download its PBIX file, if one was included.

     

    I had a good time making this Data Story, hope you enjoy it, find it useful and that it encourages you to use and create Quick Measures more often!

     

    eyJrIjoiM2VjMjUxYjctZGZmZS00YWE5LWI1ZDYtNDNmZmQyYmNmMjI0IiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9


    @ me in replies or I'll lose your thread!!!
    Become an expert!: Enterprise DNA
    External Tools: MSHGQM
    YouTube Channel!: Microsoft Hates Greg
    Latest book!:
    Learn Power BI 2nd Edition
    Preview file
    66 KB
    Quick Measures.pbix
    Labels:
    • Labels:
    • How To
    • Other
    Message 1 of 1
    1,590 Views
    6
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • 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

    © 2022 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks