cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to: visualize ideal range values with actual data

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

5 REPLIES 5
Highlighted
Frequent Visitor

How to: display max-min ideal range data and actual data

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

Highlighted
Super User III
Super User III

Re: How to: display max-min ideal range data and actual data

Hey,

maybe the CandleStick custom visual from OKviz freely available from the office store is what you are looking for. Another custom visual could also be the Trading Chart from MAQ also available in the office store.

Hopefully this gets you started


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Super User III
Super User III

Re: How to: visualize ideal range values with actual data

Hey, I guess this is a similarquestion

https://community.powerbi.com/t5/Desktop/How-to-display-max-min-ideal-range-data-and-actual-data/m-p...

Regards Tom


Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Microsoft
Microsoft

Re: How to: visualize ideal range values with actual data

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.How to visualize ideal range values with actual data .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Solution Supplier
Solution Supplier

Re: How to: visualize ideal range values with actual data

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!!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors