Dashboard shows different results in Classic and Lightning

This behavior occurs because Lightning Experience has a 100-dimension limit on dashboard groupings. Follow the steps below to identify and resolve this limitation.

In Lightning Experience, if there are more than 100 dimensions, then:

• Only the first 100 dimensions are drawn on the chart
• Custom sorting set in Salesforce Classic is lost

How to Identify the Limit

To verify this is the cause, look for a small information icon (tiny blue circle) on the chart component in Lightning Experience. Hovering over it will display the message: "Showing first 100 groupings". This confirms the dashboard component is hitting the 100-dimension limit.

How to Resolve

To avoid these limitations, consider setting report filters that return 100 or fewer dimensions. As a workaround, remove a grouping (or sub-grouping) from the report or chart to reduce the overall number of groupings.
Note: At this time, this limit cannot be increased.