Column chart not showing all labels

[GR]

Dear all

I am new to PowerApps and am working on a custom app based on a custom SharePoint List.

See also screenshot attached for additional info.

Situation

I have linked a SharePoint list which is a daily reporting tool and includes the following columns:

• Manufacturer Serial Number (MSN) (Choice)
• Task (Multiple-Choice)
• Type of Entry (Choice)
• Description (Multiple lines of text)
• Risk Level (Choice)
• Need for Action (Yes/No)
• Next Action (Date)
• Comments (Multiple lines of text)
• Created (Date)
• Created by (Person)

In order to provide some quick overview on some key columns, I am creating graphs for the following:

• Type of Reports (based on value of "Type of Entry" column) - Pie Chart
• Risk Levels Overview (based on value of "Risk Level" column) - Column Chart/Bar Chart
• Need for Action Overview (based on value of "Need for Action" column) - Column Chart/Bar Chart

Problem

Whenever I try to create a graph, the only columns for selection are "Need for Action" and "Next Action". All other columns are unavailable/not visible, so I cannot include them in the graphs.

Bypass

I have bypassed this issue with the following function for all of them (example given is for pie chart):

Table(
    {Col: "Risk alert", Value: CountRows(Filter('Daily Project Report', 'Type of Entry'.Value = "Risk alert"))
    },
    {Col: "Achievement", Value: CountRows(Filter('Daily Project Report', 'Type of Entry'.Value = "Achievement"))
    },
    {Col: "Information only", Value: CountRows(Filter('Daily Project Report', 'Type of Entry'.Value = "Information only"))
    }
)

This seems to work for both pie charts and bar charts. However, also brings some other problems:

Bypass Problem

This function works great for the pie chart, however, it does not work well on the bar charts in terms of labels. The bar chart is displayed correctly, however, the labels are missing. It only provides one label named "Value" (see screenshot)

Question

1. Why are my columns not available for selection when creating a graph?
2. For the current situation with the bypass: How can I fix the issue that the bar charts do not show the right labels?

Thank you very much in advance for your assistance. If you have questions, I would be happy to answer them.

Regards

G

[v-xida-msft · Accepted solution]

Hi @GR ,

Actually, it is an known issue with Chart controls in PowerApps app. Within canvas app, the Chart controls only accept simple data types (Text, Number, Date, Yes/No, ...) as display value, the complex data types (e.g. Choice, Person, LookUp, ....) are not supported in Chart controls.

If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, I think the AddColumns function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Column Chart control to following:

AddColumns(
          'Daily Project Report',
          "EntryType",
          'Type of Entry'.Value,
          "RiskLevel",
          'Risk Level'.Value,
          "TaskValue",
          Concat(Task.Value, Value & " "),
          "MSN",
           'Manufacturer Serial Number (MSN)'.Value
)

 then you could choose 'RiskLevel' as display label within your Column chart.

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[BT168]

Hi @GR @v-xida-msft 

I am running into the same problem when trying to create a pie chart and have tried your workaround but can't seem to get it to work. 

I have a SP list called 'Miles Challenge' with a column called 'Team' (which is a choice column) and I want the pie chart to show entries per team. 

I have tried to Add Columns and the workaround @GR described but am hitting an error. Can you help? 

Thanks.