Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Element115
Impactful Individual
Impactful Individual

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

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.

 

Screenshot 2024-02-20 214104.jpg

1 ACCEPTED SOLUTION
Element115
Impactful Individual
Impactful Individual

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.

View solution in original post

1 REPLY 1
Element115
Impactful Individual
Impactful Individual

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.