How to split line value in line and clustered column chart?

[jcaranibar]

I need to have two lines in LINE AND CLUSTERED COLUMN CHART, but based on the same variable splited according COLUMN SERIES field. I mean, I don't have another variable to add into LINE VALUES. I want to use the same variable but not accumulating into just one line. It seems that LINE VALUE does not recognize the COLUMN SERIES specification.

I cannot use formulas because I am using SSAS basically with fields: month (SHARED AXIS), type (COLUMN SERIES), budget (COLUMN VALUES), actual (LINE VALUES).

Thanks for any help.

JCA

[v-yuezhe-msft · Accepted solution]

Hi @jcaranibar,

Do you connect to SSAS data source via a live connection option? If that the case, you are not able to split line value based on type field in LINE AND CLUSTERED COLUMN CHART as you cannot create measures.

In your scenario , you can consider to connect to SSAS data source via import option, then create measures. Alternatively, create a Line chart using these fields: month, type, actual in the current PBIX file.


Thanks,
Lydia Zhang