web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Add Multiple Columns/S...
Power Apps
Unanswered

Add Multiple Columns/Series to a Column Chart

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi! I have a Column Chart based on the below 3 SharePoint Columns:

 

  1. Month Created
  2. ID
  3. Entity

I am using the below formula to:

  • Group the ID values by Month Created
  • Filter out the UK Entity

It works great, but now I want to add a second series whereby I split out the IDs for each month across the different entities.

For example, my Column Chart would show the following:

 

  • November
    • Italy: 3
    • USA: 4
    • France 1
  • December
    • Italy: 1
    • USA: 5
    • France 2

How can I add the "Entity" column into the below formula?

 

AddColumns(
GroupBy(
Filter('Reactive Support Escalations', 'CMS Entity' <> "CMS UK"),
"Month_Created",
"DATA2"),
"MonthCreatedChart",
CountRows(DATA2))

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard