Forum Discussion
line chart with multiple values in legend limitations
I am trying to plot more than 10 values in a single legend in a line chart. But am able to see only 10 values.
for example: if i have 15 products, and i am showing sale of those products across the year, using line chart. Able to plot all the products in the chart but the legend is showing only 10 values.
Is this a limitation or do we need to change some settings.
6 Replies
- bjstigallFrequent Visitor
I have also hit the 10 row limit (we have 12 cylinder engines). Is there a place to vote to up this limit? Maybe turn off tool tips and the limit goes away?
- AnonymousNot applicable
Hi Vipul,
I can't reproduce your issue, it can shows more than 10 legends.
Current line chart not contains the limitation about legend, but if your table contains too much records, it may shows '!' at left top corner and told you too much data.
Regards,
Xiaoxin Sheng
- VipulNew Member
Let me clarify.
The legends are visible as mentioned by you, but when we hover over the line chart for a single value on x-axis, there we could see only 10 values at a time.
Is there a way to customise that visibility.
- AnonymousNot applicable
Hi Vipul,
>>The legends are visible as mentioned by you, but when we hover over the line chart for a single value on x-axis, there we could see only 10 values at a time.
Based on test and the feedback form team, It seems like tooltips have limitation about display amount.
"Unfortunately By Design right now, we only show 10 rows of data. If you have additional tooltip values, this causes you to hit the 10 row limit with only a few series (as shown in this example).
We have a Scenario planned to introduce a "Tooltip Formatting" property card that will include this and other tooltip options, hopefully in the next 6 months it will be prioritized and completed."For your requirement, I'd like to suggest you share this to ideas forum to help improve the line visual.
Regards,
Xiaoxin sheng
- AnonymousNot applicable
Hi Vipul
It can be done with the help of Perspective.
You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools
Here is the link to the steps.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives