Showing results for 
Search instead for 
Did you mean: 

Truncated legends: Line chart cannot display all legends

Background: We are developing a report that can be customized by viewers. This includes allowing the viewer to custom the vertical axis and legend in the line chart.


(In consideration of compliance, part of the information in the picture is hidden)



In a line chart with legends, if there are many values ​​for the legend, PowerBI will automatically truncate the legends in alphabetical order, and only display the legend and the corresponding line in the alphabetical order, which will significantly mislead the viewer. Legends with lower rankings may not be displayed at all even if they have larger values as below.


There is a metrix "Value" we want to show by "Calendar" and "SomeMetrix" which is lengends in this line chart. The pie chart on the right shows the percentage of each legend, where the "R..."s has the max percentage for Value. But PowerBI will automatically truncate the legends in alphabetical order, and only display the legend and the corresponding line in the alphabetical order. So the linechart even doesn't show the line for "R..."s. 



I know that by setting a filter on the line chart, only the legend that makes the vertical axis sort Top N can be displayed.  





But in our scenario, when viewers watch in PowerBI Service, we want them to customize the vertical axis and the legend. The custom of this filter requires every viewer to have editing permissions, which is unrealistic for us.


Therefore, our needs can be summarized as:
(1) Is there a way to configure PowerBI to make the line chart display all the legends and the corresponding line, even if the legend has many values?
(2) If truncation cannot be avoided, is there a way to configure PowerBI so that the line chart can automatically select the legend with the larger vertical axis instead of truncating according to the alphabetical order.

Not applicable



I have similar problem and fix it by coincidence



Step 1: Make new table with 1 column using formula Calendar (Dates according your prefference) and call "Calendar Date"

Step 2: Make relationship between "Calendar Date" and Column with date of your original table


If you already made this when you begin your PBI dashboard you only need go TABLE view and refres formula Calendar with dates again (PBI will update links and everything) you can come to see main chart and this time all legends will be visible 

Community Support
Community Support

Hi @yyu ,


I'm not very clear about the scenario you described, can you share some screenshots?


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Thank you for your reply, I very much hope to get further help.

In order to explain my question more clearly, I updated the question and added pictures.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors