Forum Discussion
Combo chart
I'm not sure where you're running into trouble. You can definitely add multiple fields to the Line y-axis box.
I'm not sure where you're running into trouble. You can definitely add multiple fields to the Line y-axis box.
Curious why when switching from a 'Clustered Column' (values by all months and several years) to 'Line and Clustered Column' (drag the values field from Column Y-Axis into the Line Y-Axis), PBI adds together the values for all months and omits years?... calculation is set to 'no calculation' on the 'show value as'... really a strange thing that I can't get to resolve. Maybe because there's not a 'Line Y-Axis Legend' to drag years into... IDK.
Interestingly, when I drag the values field into the 'Small Multiples' field, the engine correctly infers year context, but unfortunately breaks each year into a separate mini-chart for each year.
If I switch to the chart type of 'Line Chart', the correct context is rendered there, too... but just need to get the column component, like in Excel with the 'Combo Chart' option (tangent/venting: the PBI team should have Combo Chart in this software, IMO... MS Office products should leverage continuity between apps whenever possible, especially from Excel into PBI).
For what it's worth, I believe the issue with not having multiple lines work automatically is that there isn't a 'Line Legend', but there is for columns. So it appears if you want separate lines for each year, you have to write a different formula filtering for each year.
Excel is so much more customizable.
