Hi all,
I want to stack a table with multiple unique legend.
So basically, the stacked chart should not be summarised, but should display values by same item multiple times in the correct order.
Please have a look at the image for better understanding 🙂
Any ideas how I can do that in PowerBi?
Marco
Anonymous
Hi can you explain what your objective is, what are you trying to show, you need to aggregate on something to use the stacked barchart, so i am not sure this is the right chart for you. What are you trying to compare?
Boreholes.
I want to show layers of a borehole as they occur.
Please see the attached image 🙂
Anonymous hi yes i saw the picture previously, but as i said, you will need to use some form of aggregation. Can you post the data here rather than a picture?
Have you tried to use itemWidth parameter?
Please take look at
http://jsfiddle.net/B9L2b/1266/
legend: { width: 200, itemWidth: 100 },
//api.highcharts.com/highcharts#legend.itemWidth
EDIT:
width:600, itemWidth:300, itemStyle: { width:280 }
//api.highcharts.com/highstock#legend.itemStyle
I hope this information helps!
Regards,
Lewis
Tech-consultant
HI Anonymous
It can be done with the help of Perspective.
You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools
Here is the link to the steps.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives
