Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
58 |