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 All,
I am trying to create a min, max, and average column chart; I have seen an existing solution using stock charts for the min/max but that requires the use of dates. I am trying to create a visual shown below; that uses categories along the x-axis.
I have tried a box-whisker plot also, but it is not entirely relevant based on my data-set.
Thanks.
Solved! Go to Solution.
@Anonymous
See the pbix file here containing the chart with your sample data
Hi @Anonymous,
You'd better post your sample data and desired result, so that we can share detailed solution which is close to your requirement. It's really hard to reproduce your scenario without sample data.
Thanks,
Angelia
Apologies, I have attached the sample data. The idea is the minimum value will stem from the relevant minimum value within the category, rather than the minimum of the entire data set.
Thanks.
Hi @Anonymous
Try "Line and stacked column chart"
Put the Min and Max in Column values
Put the average in Line Values
Uncolor the Min Column
@Anonymous
See the pbix file here containing the chart with your sample data
@Anonymous
I only know this technique.
Hopefully someone will point out a better solution
Perfect! It makes sense; Thank you for your efforts.
That is what I am using currently, like abusing the stacked and line chart, but it is a not really a "true" representation, correct?
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 |
---|---|
113 | |
92 | |
86 | |
76 | |
66 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |