cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GR
Frequent Visitor

Column chart not showing all labels

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

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,

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

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

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,

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

View solution in original post

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. 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,319)