skip to main content
  • Products
    • What is Power BI
    • Why Power BI
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
  • Solutions
    • Customer showcase
    • Partner showcase
    • Data Stories
    • Power BI Visuals
  • Partners
    • Overview
    • Partner showcase
    • Find consulting services
    • Find a partner
    • Become a partner
  • Learn
    • Overview
    • Guided learning
    • Documentation
    • Support
    • Developer center
    • Community
    • Roadmap
    • Give feedback
    • Webinars
    • Blog
  • Community
    • Overview
    • Forums
    • Galleries
    • Ideas
    • Issues
    • Events
    • User groups
    • Community blog
  • Sign in
  • Sign up free
  • Products
    • What is Power BI
    • Why Power BI
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
  • Solutions
    • Customer showcase
    • Partner showcase
    • Data Stories
    • Power BI Visuals
  • Partners
    • Overview
    • Partner showcase
    • Find consulting services
    • Find a partner
    • Become a partner
  • Learn
    • Overview
    • Guided learning
    • Documentation
    • Support
    • Developer center
    • Community
    • Roadmap
    • Give feedback
    • Webinars
    • Blog
  • Community
    • Overview
    • Forums
    • Galleries
    • Ideas
    • Issues
    • Events
    • User groups
    • Community blog
  • Sign in
  • Sign up free
  • Register
  • ·
  • Sign In
  • ·
  • Help
Go To
  • Galleries
  • Gallery Forum
  • Themes Gallery
  • Data Stories Gallery
  • R Script Showcase
  • Webinars and Video Gallery
  • Quick Measures Gallery
  • MBAS 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
Regular Visitor
92003 Views
LinkedIn LinkedIn Facebook Facebook Twitter Twitter
Highlighted
jolsby
jolsby Regular Visitor
Regular Visitor

Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎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

ExecutiveInsightsArrow2.pngAdded Interactivity

ExecutiveInsightsArrow.png

eyJrIjoiYTYxMzllYjQtYjU5NS00MTM4LTlmMjEtMTY0NzVkM2U4OGE4IiwidCI6IjdlY2M4YWEwLTgzMGUtNGQ4Ni1hZjc4LTgzYTNkY2MyNjIzOCIsImMiOjZ9

ExecutiveInsightsArrow.png
Labels:
  • Business
  • Economics
  • How To
  • Technology
Message 1 of 28
92,003 Views
107
Reply
JanV
JanV
Advisor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎06-26-2017 03:44 AM

Great dashboard,

@OwenAuger might be able to help you out with your food for thought 

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

https://www.dropbox.com/s/59cct4in6zqbxaj/Sales%20Top%20Other.pbix?dl=1

 

Message 2 of 28
90,616 Views
0
Reply
Fitin1rb
Fitin1rb Member
Member

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎06-30-2017 01:01 PM

Awesome Dashboard.  I have a question regarding your dynamic filter (Revenue, Profit, Quantity).  How are you able to make that filter dynamically change the entire dashboard?  Is this a DAX function you created for that?

 

Thanks!
Ryan

Message 3 of 28
90,305 Views
0
Reply
jolsby
jolsby Regular Visitor
Regular Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎07-03-2017 12:37 PM

Hi Ryan,

 

You can find a full tutorial on dynamic visuals here. It was this post that refrenced, if you want to read how to approach the subject.

 

Moreover, you can use the Concatenate DAX function to combine your dynamic fields and any other information you would like to include. I used Concatenate to add dynamic questions, which grounds the reader in what they were looking at.

 

Best,

Jake

Message 4 of 28
90,210 Views
0
Reply
mjmar025
mjmar025 Regular Visitor
Regular Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎07-19-2017 06:32 AM

Love this dashboard - very clear and easy to understand at first glance. I am wondering though - how were you able to get the darker gray bar at the top to go edge to edge on the canvas? Can't seem to figure this out.

Message 5 of 28
89,073 Views
0
Reply
jolsby
jolsby Regular Visitor
Regular Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎08-02-2017 04:05 PM

Hi there!

 

You will want to use a text box, make it 0% transparent, so it appears as solid square.

 

For whatever reason, the text box feature goes to the edge, but not the square shape image.

 

Best,

Jake

Message 6 of 28
88,153 Views
0
Reply
tannera
tannera Regular Visitor
Regular Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎08-22-2017 06:43 AM

Great work. But what happens if all countries reach 1bn in revenue? The map would be covered. 

Message 7 of 28
87,371 Views
0
Reply
citruslab
citruslab Frequent Visitor
Frequent Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎11-11-2017 06:49 AM

Hey Jolsby, This is an awesome UI. Is it possible to download the .pbix of this report by any chance?

Message 8 of 28
83,293 Views
4
Reply
radnajela17
radnajela17 Visitor
Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎11-12-2017 12:19 PM

Hi Jobsly!!

Is it possible to download the .pbix of this report by any chance?

 

Thank so much 🙂

Message 9 of 28
83,214 Views
4
Reply
hoffmanrat
hoffmanrat Frequent Visitor
Frequent Visitor

Re: Executive Insights by Decisive Data

  • Mark as New
  • Bookmark
  • Subscribe
  • Mute
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎11-20-2017 10:26 PM

Great report.

 

I wonder what the plan is around when your data bars encroach into your map visual? Given there wouldnt be any dynamic resizing happening. Did you test that against the data and determine the likelihood of it was too low for it to be a valid consideration?

Message 10 of 28
82,674 Views
0
Reply
  • « Previous
    • 1
    • 2
    • 3
  • Next »
  • 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
  • © 2019 Microsoft
  • Privacy & cookies
  • Terms of use
  • Trademarks