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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Element115
Super User
Super User

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
Super User
Super User

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
Super User
Super User

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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