Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
08-15-2017 03:11 AM - last edited 08-15-2017 03:29 AM
Arrow Rating
This quick measure shows an up arrow or down arrow when comparing a target value against a target value, or else "--" if not. Can also be inverted if a lower value is better compared to the target.
Name: Base Value
Tooltip: Your base value / measure.
Type: Numerical field / measure
Name: Target
Tooltip: The value / field you wish to compare base value against.
Type: Numerical field / measure
Name: Inverted
Tooltip: Toggle whether lower value is better compared to the target.
Type: True / False
A simple measure created with the UNICHAR function which was introduced to me by Chris Webb's quick measure and blog, so a big thanks to him. The measure uses some simple IF logic, making use of the switch function also. Using Chris's quick measure has encouraged my use of variables within DAX so I hope this can create some value to some people.
This quick measure would also benefit from conditional formatting (red or green for good or bad) however currently this is only applicable to numerical fields currently.
Thanks all!
Gordon
eyJrIjoiYTMwZjQ5Y2QtOTU4MC00ZWViLWFmZWItYWE2MjkyMWMxNjcxIiwidCI6ImRkYzVlNDUwLTM5NzUtNDEzOC05N2M4LTQxN2U4MmVmYWIyNSIsImMiOjh9
This is great! Thanks for contributing, is it possible to change the colors of the arrows?
Yes. You can change the colour of the arrow on the format section.