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'm trying to create a "stacked" chart where each value is displayed individually, but don't aggregate. In other words, if I'm trying to display a minimum, average and max value, each is displayed against the corresponding axis and as part of the maximum value: ie they don't all add up to a total. The visual would look something like this:
It is similar to the Stock Chart visual (but I need a category on the x-axis and not a date). I tried both the custom visuals "Candlestick" and "Box and Whisker" but can't get them to display what I need.
Any ideas?
(EDITED: Apart from creating new measures which are the difference between them to stack them up that way, which wouldn't allow to display the absolute value for each)
Thanks!
Paul
Proud to be a Super User!
Paul on Linkedin.
Solved! Go to Solution.
In this scenario, you just need to create a calculated table to summarize the min, max and average into columns.
Table = SUMMARIZE ( Category, Category[Category], "Min", MIN ( Category[Value] ), "Average", AVERAGE ( Category[Value] ), "Max", MAX ( Category[Value] ) )
Regards,
In this scenario, you just need to create a calculated table to summarize the min, max and average into columns.
Table = SUMMARIZE ( Category, Category[Category], "Min", MIN ( Category[Value] ), "Average", AVERAGE ( Category[Value] ), "Max", MAX ( Category[Value] ) )
Regards,
Hello,
I just tried the solution, but it still aggregated the at the axis level and it is not different from the normal stacked chart. I have provided the visual below.
I created the column using the code provided, but the visual I can also achieve by repeating the same filed and selecting it as minimum, average, and maximum respectively.
Thanks for your efforts.
Thank you Simon!! That's exactly what I needed!
Proud to be a Super User!
Paul on Linkedin.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |