Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello folks, I need some help here if you please.
I am trying to visualize 3 cathegories of data in a combined way, like the following:
- range maximum: a reference value for maximum
- range minimum: a reference value for minimum
- actual: the actual performance achieved (it can be below, inside or above the reference range)
I actually could do it on excel using two stacked columns, one for max and other for min, and "hiding" the minimum stack. However, I needed to recalculate the maximum value, so the lenght of the max column would be equal to the difference between the max and min. But I could make Excel display custom data at the data label.
For example:
- max value displayed: 20
- min value displayed: 16
- min column lenght: 16
- max column lenght: 4 (20 - 16)
- actual value performed: 17,5
Do you guys know any way of building this in power bi?
Thank you
Hello @brucruz,
We hope that 'Box and Whisker by MAQ Software' have solved your purpose.
If you are facing any issues with the visual implementation, we can be reached at support@maqsoftware.com
Thanks!!
Hi @brucruz,
A sure thing is you need a custom visual. Try the Box and Whisker chart from Store. If you want more help, please share a sample.
Best Regards!
Dale
Hello folks, I need some help here if you please.
I am trying to visualize 3 cathegories of data in a combined way, like the following:
- range maximum: a reference value for maximum
- range minimum: a reference value for minimum
- actual: the actual performance achieved (it can be below, inside or above the reference range)
I actually could do it on excel using two stacked columns, one for max and other for min, and "hiding" the minimum stack. However, I needed to recalculate the maximum value, so the lenght of the max column would be equal to the difference between the max and min. But I could make Excel display custom data at the data label.
For example:
- max value displayed: 20
- min value displayed: 16
- min column lenght: 16
- max column lenght: 4 (20 - 16)
- actual value performed: 17,5
Do you guys know any way of building this in power bi?
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |