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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Column chart - show co...
Power Apps
Answered

Column chart - show columnby month in chart

(0) ShareShare
ReportReport
Posted on by 28

Hi Everyone,

I'm facing with column chart. I have an application for user raise issue and the result will be show on chart . The issue have 3 level: Low ,Medium, High. I would like to show the report by month. But i just can show total by month. How i can show level and total by month ? 

 

AddColumns(GroupBy(AddColumns('IT request',"MonthName",Text(DateRequest,"[$-en-US]mmmm")),"MonthName","Grouped"),"Count",CountRows(Grouped))

 

ITSYS_0-1684292820785.png

 

Categories:
I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @ITSYS,

    Please modify you formula as below:

     

    AddColumns(
     GroupBy(AddColumns('IT request',"MonthName",Text(DateRequest,"[$-en-US]mmmm")),"MonthName","Grouped"),
     "Low",
     CountRows(Filter(Grouped,Level="Low")),
     "Medium",
     CountRows(Filter(Grouped,Level="Medium")),
     "High",
     CountRows(Filter(Grouped,Level="High"))
    )

     

    Note the following tips:

    1). Set the number of series as 3 because you have three levels

    2). Set the Labels as MonthName

    3). Set the Series as Low ,Medium, High

    vqiaqimsft_0-1684297240230.png

     

  • ITSYS Profile Picture
    28 on at

    Hi Qi,

    It's Great. My chart has show as my mind. Thanks a lot.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard