BUG::Field params don't play well with line+clustered column chart

[Element115]

ISSUE:  look at the screenshot, it speaks for itself.  

There is no way to assign one field param to one line, and the other to the columns, which is not how this chart behaves when NOT using field params, ie table columns. In the latter case, the y-axis and secondary y-axis will assign one graphical element to each table column, line for one and columns for the other.  

But showing both series as 2 lines and 2 series of columns serves no purpose other than to clutter the viz even more.

[Element115 · Accepted solution]

If using only one field param table, PBI does not automatically assign one field value to a line and another to a column, but will assign each and every field value to be represented both as a line and a column.

Solution:  instead of putting all your fields into one param table, split the param table, ie have 2 param tables. Assign to one the fields that you want to see as lines, and to the other, the fields you want to see as columns.