Line and clustered column chart - value not showing as a line

[Anonymous]

Hi,

I have a line and clustered column chart where I am wanting the forecast average to come through as a line. It's only showing as a dot and I am struggling to find how to change this.

All the values are measures I have made. Is there any way I can change this to a line?

Thanks

[Ashish_Mathur]

Hi,

Your data is not well structured.  You shoould definitely ot have the need to drag 12 fields to the Columns section.  Perhaps you need to use the "Unpivot Other columns" feature of the Query Editor.  To get more specific help, share the link from where i can download your PBI file.

[PhilipTreacy]

Hi @Anonymous 

Can you please share your PBIX file.

When I set up some dummy data I don't get the same problem

How have you set up the Values Measures?

What have you got on the Shared Axis?

Regards

Phil