Power Platform Community Forum Thread Details

Since you are working with a SharePoint list and a Column Chart, the issue likely arises because SharePoint stores Choice column values differently. The legend might only be showing one value instead of all unique values.

Solution Approach

You need to explicitly define the Legend values by setting Items of the chart properly and ensuring that the data is grouped correctly.

Steps to Fix the Legend Display Issue

Ensure Your SharePoint Data is Correctly Structured
- If Qty is a Choice column, SharePoint stores it as a table rather than a plain number.
- Instead of ThisItem.Qty, you may need to extract the .Value like:
  
  ThisItem.Qty.Value
Use the GroupBy Function to Aggregate Data
- If your Qty values are stored as choices, group them properly using:
  
  ClearCollect( colChartData, AddColumns( GroupBy( ListA, "Qty", "GroupedData" ), "Count", CountRows(GroupedData) ) )
Bind the Chart to the Collection
- Set the Items property of the Column Chart to:
  
  colChartData
Configure the X-Axis and Y-Axis
- X-Axis: Qty
- Y-Axis: Count
Ensure Legends Display Correctly
- If ColumnChart.SeriesLabels is not working, manually define the Legends using:
  
  ColumnChart.Legends = Distinct(ListA, Qty.Value)
- OR if stored as text, use:
  
  ColumnChart.Legends = Distinct(ListA, Qty)

Final Expected Result

The column chart should now show Qty values (10, 20, 30, 40, 50) as separate bars.
The legend should display all values correctly.
The chart should properly group duplicate values.

Please click Accept as the Answer ✅

If my post helped you solve your issue. This will help others find it more readily. It also closes the item. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it a Like 👍