Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
108 | |
93 | |
70 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |