Re: Sales Scorecard: Where are we losing money? by Decisive Data
06-04-2018 06:17 AM
Re: Sales Scorecard: Where are we losing money?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-12-2017 12:55 PM
4/12 Update: Simplify using UNICHAR
I just discovered the UNICHAR function in DAX, and used this to simplify my process! Currently we have 2 elements for each indicator, for a total of 8 elements. This method cuts the elements in half!
- Delete the tree maps and the arrow objects
- Delete the KPI Red/Green measures for Sales and Profit (4 total)
- Create 4 new measures
- Sales Indicator Positive = IF(AND(HASONEVALUE('Date'[Fiscal Year]),'Sales Scorecard'[Sales YoY Growth]>0),UNICHAR(11205),"")
- Sales Indicator Negative = IF(AND(HASONEVALUE('Date'[Fiscal Year]),'Sales Scorecard'[Sales YoY Growth]<0),UNICHAR(11206),"")
- Profit Indicator Negative = IF(AND(HASONEVALUE('Date'[Fiscal Year]),'Sales Scorecard'[Profit YoY Growth]<0),UNICHAR(11205),"")
- Profit Indicator Positive = IF(AND(HASONEVALUE('Date'[Fiscal Year]),'Sales Scorecard'[Profit YoY Growth]>0),UNICHAR(11206),"")
- Put each measure in a separate card.
- Change the Data Label colors to make the down arrows red and the up arrows grey
- Arrange your arrows and you're done!
With this method, we are using the UNICHAR to display UNICODE arrow characters. Since we're doing this in DAX, we can us IF statements to hide/show the arrows based on our measures, which means we no longer need to use the tree maps as covers, cutting our number of elements in half! Less elements = easier to maintain.
Enjoy!
Decisive Data | www.decisivedata.net
Re: Sales Scorecard: Where are we losing money?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-13-2017 07:48 PM
Aesthetically pleasing and well thought-out. I like the way you thought outside of the box (big time!) with regard to the KPI. This is a very well-organized and actionable report. Thanks for sharing!
Re: Sales Scorecard: Where are we losing money?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-20-2017 09:54 AM
You can use Word or other more advanced text editor (able to produce symbols) instead to produce "dots". Then just use color formatting in text visual in Power BI to make them red and gray.
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-04-2018 11:42 AM
Highly informative, visually appealing report! Even more, I appreciated the writeup and the time it took to document your methodology. Thanks for sharing! -Ellen
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-23-2018 10:27 PM
Awesome work Jared. Its surely out of box thinking...
Could you please share the PBIX file of this scorecard to owenitian@gmail.com if you dont mind.
Re: Sales Scorecard: Where are we losing money?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-04-2018 06:15 AM
Hello Jared,
would you be willing to share this Pbix file with me? My email is adrewmc1@gmail.com
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-04-2018 06:17 AM
Hello Jared,
Would you mind sharing the Pbix file for this report with me? my email is adrewmc1@gmail.com
Thank you
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-18-2018 06:31 AM
@JaredK, really great , i just visited your Gallary and find this is really amazing and helpful.
But i still have no idea how to get the Bar Chart in Between red and gray.
i also use Color Saturation , and i set the mimium and maximium , but the between data still can't get it right to the red color.
Would you please to let me know how the trick you use on this case ?
You're amazing
thx
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
09-20-2018 08:39 AM
Have you tried using the 'Diverging' Option in the Data Colors format options when you have the bar chart selected?
I believe that should do the trick?
Matt
Re: Sales Scorecard: Where are we losing money? by Decisive Data
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-04-2018 01:57 AM
Hello Jared,
Would you mind sharing the Pbix file for this report with me? my email is guidotreur@yahoo.com
Thank you