Forum Discussion
Combo Chart with multiple Lines and one Column
I know this was asked last year here: https://community.powerbi.com/t5/Desktop/Combo-Chart-with-multiple-Lines-and-one-Column-instead-of/m-p/297145#M131128
I am hoping Power BI has evolved since then and maybe we have a better solution. I too have similar need as the one posted in the above link. Proposed solution to create measures for each line chart and dropping them in the Line Values may work if the number of line charts required is a known number. I have to display the line charts based on Feature attributes selected from a slicer. I have two slicers, one for selecting a feature and the second which provides the list of attributes. My combo chart would look something like in the image below. It has line charts for each attribute and the bar is for all the availble attrbutes combined for the selected feature. Is there a way to create this chart?
2 Replies
Hi ravimerugu,
I don't think there is a better solution in Power BI currently. I would suggest you add it as an idea on Power BI Ideas forum to improve Power BI on this feature.
Proposed solution to create measures for each line chart and dropping them in the Line Values may work if the number of line charts required is a known number. I have to display the line charts based on Feature attributes selected from a slicer.You can just create measures for each possible Feature Attributes, and put all of them on Line values field on the combo chart. If a Feature Attribute is not selected from the Slicer, it won't be displayed on the combo chart. :smileyhappy:
Regards
Thanks v-ljerr-msft. Creating multiple measures is not an option for me since there are a lot of attributes. I submitted the idea for a combo chart with multiple line charts anda column chart here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32550865-combo-chart-with-multiple-line-and-column-charts.
I request the readers of this post to vote if they find it useful.
