cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: Column chart not showing all labels

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

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Column chart not showing all labels

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

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,683)