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
    • Executive Insights by Decisive Data

    Executive Insights by Decisive Data

    05-24-2017 09:35 AM

    jolsby
    Advocate IV
    243494 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    jolsby
    jolsby Advocate IV
    Advocate IV
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Executive Insights by Decisive Data

    ‎05-24-2017 09:35 AM

    Summary

    Often asking, “How are we performing?” can be a question that cascades into a series of further questions, spinoffs and investigative research. This is especially true for globally minded companies. I wanted to create a report that preemptively addressed this kind of exploration. This report is meant to provide data-driven decision making, while emphasizing user-flexibility and visual analysis. I was able to achieve my goal to empower the user by leveraging dynamic visuals. Thus, this dashboard can scale as the needs of the global business changes.

     

    Approach

    A dashboard is most valuable when you immediately understand what you can do. I looked into what attributes that can be influenced by the company:

    • What we are selling (products)
    • When we are selling (year)
    • Where we are selling (country)
    • How we are selling (order type)

    The focus here is to view the business from multiple angles for these attributes, providing a holistic approach to the business, through dynamic parameters. I was able to provide deeper analysis with Top/Bottom products, YoY growth and Running totals to name a few. I leveraged, bar charts, line charts, donut charts and custom visuals for visual analysis.

     

    Pushing the Boundaries

     

    There were two things I wished to achieve with this dashboard, attractive mapping and next-level user interactivity.

     

    I wanted to have a map that was design oriented and subtle, like an art piece, meant to invite the user into the dashboard. If users are going to be using a report all the time, why not make it pleasing to the eye? I found that design piece with the new “Shape Map” feature, where one can import custom TopoJSON files. I edited and imported a custom world map from http://mapstarter.com/. The simple map was meant to ground the user geographically and compliment the adjacent bar chart, which holds the same information.

     

    Moreover, I am a firm believer that interactivity is empowering. Giving users the tools to investigate data on their own terms is liberating. As such, I wanted to provide two layers of dynamic parameters. This was done with a Top 5/Bottom 5 measure that reflects whatever measure the user has selected at the top of the dashboard. This was executed within DAX. The question I wanted to be able to answer was “What is my [Top/Bottom] products by [Value]?” in one, simple, clean visual.

     

    For the first part of this method of creating dynamic measures, I was inspired by Sam McKay’s wonderful blog post on Dynamic Visuals, within Power BI. This provided me the groundwork for my dynamic values, and how I would approach the rest of this problem.

     

    Now came the real challenge. I had to build two ranks on a value that could change with a click. To do this I set my dynamic parameter as two rank fields, one Ascending and the other to Descending, for the respective ends of the product performance. These were calculated across my desired field, Products.

     

    Next, I needed to filter each of these Ranks to only keep the Top 5 Products. This can be down with two IF statements, keeping the Rank with only five values or else appearing as BLANK(). Once the IFs are built, you can then build another selector table with McKay’s method with a “Top 5” and “Bottom 5”, which can eventually be used with a SWITCH function to include only the [Filtered Rank DESC] or the [Filtered Rank ASC].

     

    The result means that instead of six individual bar charts, one for a Top or Bottom, across three measures, Quantity, Revenue and Profit, you end up with one, dynamic visual. The result empowers users and saves valuable real estate for other interesting insights.

     

    Quality over quantity.

      

    Wrapping it up

     

    The dynamic parameters and tables worked very well, but it took a little research to have the two dynamic parameters work in conjunction, as I had yet to see any specific topic utilize such before in Power BI. Another aspect that comes to mind, is whether one could make the number of values, in this case 5, also a parameter, so you could select how many TopN you are seeing. Food for thought. In the end, it’s great to know that great visuals can be created just with DAX, determination and some trial and error.

     

    Overall, with the combination of the custom visuals, and dynamic parameters, I created a clean dashboard for analytical insights that’s also a pleasure to interact with.

     

    Jake Olsby

     

    Decisive_Data_Vector_Logo.png

    Added InteractivityAdded Interactivity

    ExecutiveInsightsArrow.png

    eyJrIjoiYTYxMzllYjQtYjU5NS00MTM4LTlmMjEtMTY0NzVkM2U4OGE4IiwidCI6IjdlY2M4YWEwLTgzMGUtNGQ4Ni1hZjc4LTgzYTNkY2MyNjIzOCIsImMiOjZ9

    Preview file
    223 KB
    Labels:
    • Labels:
    • Business
    • Economics
    • How To
    • Technology
    Message 1 of 144
    243,494 Views
    189
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    bkhole27
    bkhole27
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Wednesday

    Awesome Dashbaord 😍

    Will you please send me the pbix file on bhagyashri1.k27@gmail.com? 

    Message 144 of 144
    975 Views
    0
    Reply
    guliPOWBI
    guliPOWBI
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Wednesday

    Great Dashboard! 

    Congratulations! Could you please share the pbix file to the following email address

    gulisano.alessandro@gmail.com 

    thanks

    AG

    Message 143 of 144
    1,017 Views
    0
    Reply
    AhmedHassan
    AhmedHassan
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Wednesday

    It is very well organized Could you please share PBIX ahmed.hassan@danone.com

    Message 142 of 144
    1,035 Views
    0
    Reply
    zachlepla
    zachlepla
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-20-2022 06:00 PM

    Hello, love the view! Could you please share PBIX file?  zach.lepla@ivytech.com 

    Thank you!

    Message 141 of 144
    1,333 Views
    0
    Reply
    SebCout
    SebCout
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-20-2022 05:12 AM

    Hi, it's a  well done job. congrats. If possible i would like a copy a your pbix to understand how you filter a matrix with top5/bottom5

    regards. 
    my email sebastien.couture2@iaah.ca

    Message 140 of 144
    1,439 Views
    0
    Reply
    OSFAMARSUTHERLA
    OSFAMARSUTHERLA
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-16-2022 03:27 PM

    Love the design and features! Amazing job! 

     

    Is there any chance you could share it? 

    omar.fajardo1@sutherlandglobal.com

    Message 139 of 144
    1,839 Views
    0
    Reply
    Nnaanaa
    Nnaanaa
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-16-2022 02:15 PM

    Congrats! very nice dashboard:) I would like to have a copy please : n.nadianaanaa@gmail.com

    Thanks a lot !

    Message 138 of 144
    1,854 Views
    0
    Reply
    igogogo
    igogogo
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-14-2022 01:57 AM

    Sharp and greate design, could you share pbix igoldobin@gmail.com

    Message 137 of 144
    2,369 Views
    0
    Reply
    tarz
    tarz Helper III
    Helper III
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-06-2022 07:37 AM

    Great Dashboard! Congratulations! Could you pleasse share the pbix file to tarz87@libero.it. Thanks

    Message 136 of 144
    3,503 Views
    0
    Reply
    Saksham_Verma
    Saksham_Verma
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎06-06-2022 07:25 AM

    Superbb Dashboard !! Could you please send me pbix file sakshamverma326@gmail.com . Thanks in advance 😊

     

    Message 135 of 144
    3,510 Views
    0
    Reply
    Felix_Mintah
    Felix_Mintah
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-31-2022 06:54 PM

    Great Dashboard! could you please share the PBIX file mintahfelix@yahoo.com Thanks in advance!

    Message 134 of 144
    4,225 Views
    0
    Reply
    poseidon1971
    poseidon1971
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-27-2022 01:23 PM

    Hi! Congratulations! Could you pleasse share the pbix file franciscoazevedo@fmcenter.com.ve Thanks

    Message 133 of 144
    4,705 Views
    0
    Reply
    CBG_PBI
    CBG_PBI
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-24-2022 04:52 AM

    Can I also please get a copy of this pbix file.  This is exactly what I need for a current project.   cathy.grecki@bcbsnc.com

     

     

    Message 132 of 144
    5,315 Views
    0
    Reply
    sim_123456
    sim_123456
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-22-2022 10:41 AM

    Could you pleasse share the pbix file at swtsimmi2719@gmail.com, it will be really helpful to me. I will be highly obliged. Tank you in advance

    Message 131 of 144
    5,634 Views
    0
    Reply
    Long_Axis
    Long_Axis
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-18-2022 10:17 PM

    Hi Jake,

     

    Can you send me the .pbix file to hoanglong@axisgroup.vn, please? Your dashboard is so impressive and I want to learn something from it.

    Message 130 of 144
    6,185 Views
    0
    Reply
    Francine_gemmy
    Francine_gemmy
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-17-2022 08:56 AM

    Hi Jake,

    What an awesome dashboard. Could you please share the pbix file to francineb@gemmy.com? I would like to learn from it. Thank you! 

    Message 129 of 144
    6,573 Views
    1
    Reply
    MoustafaHakamEG
    MoustafaHakamEG
    Frequent Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-14-2022 06:23 AM

    Can I also get this *.pbix file? mostafahakam@gmail.com

    Message 128 of 144
    7,074 Views
    0
    Reply
    kola
    kola
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-12-2022 01:50 AM

    can I also get this *.pbix file? akolade.adetola@gmail.com

    Message 127 of 144
    7,375 Views
    0
    Reply
    fcucek
    fcucek
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-10-2022 12:12 AM

    could i also get this *.pbix file? floriancucek@outlook.at

    Message 126 of 144
    7,764 Views
    0
    Reply
    ukaleese
    ukaleese
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    ‎05-04-2022 12:51 PM

    Please can you email me a copy of the .pbix Andrew.leese@eternis.co.uk 

     

    regards

    Andrew

    Message 125 of 144
    8,491 Views
    0
    Reply

    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