12-20-2016 12:52 PM - last edited 05-30-2017 09:20 AM
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!
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.
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!
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.
Highly informative, visually appealing report! Even more, I appreciated the writeup and the time it took to document your methodology. Thanks for sharing! -Ellen
Awesome work Jared. Its surely out of box thinking...
Could you please share the PBIX file of this scorecard to email@example.com if you dont mind.
@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 ?
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?