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,
I need to show a chart showing price ranges accross multiple companies. For each company I have a minimum and maximum value to show. I was trying to use the trading chart, but it seems I need a date value for the X-axis instead of company.
Any ideas?
Thank you.
Solved! Go to Solution.
Hi @Elisa_E,
Current power bi not support to setting start point of chart.
For your requirement, I'd like to suggest to you to take a look at 'gantt' and 'box and wisker chart', they seems suitable for your requirement.
In addition, you can also submit this to ideas forum.
Regards,
XIaoxin Sheng
Hi @Elisa_E,
You can try to use clustered column chart to achieve your requirement.
Sample:
Company to axis field, amount columns to value fields with different summary mode.(max and min value)
Regards,
Xiaoxin Sheng
Thanks for the reply. Ideally what I needed was for column to represent the range (like floating columns), with start point at the minimum and end point at the maximum, accross the different companies (like the image below).
Maybe there is an easy way to format this from using a stacked column, but I haven't been able to see it as of yet.
Hi @Elisa_E,
Current power bi not support to setting start point of chart.
For your requirement, I'd like to suggest to you to take a look at 'gantt' and 'box and wisker chart', they seems suitable for your requirement.
In addition, you can also submit this to ideas forum.
Regards,
XIaoxin Sheng
Many thanks for the suggestions. I will give these a try.
Hi,
I am wondering if it is possible to add a dot or somehow highlight the most recent value in the time series on a box and whisker plot? Instead of the mean dot, could I use the latest value instead? Can I change the definition of the mean possible?
Alternatively, are there other charts which would show a price where I could also highlight the current value?
Thanks
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |