web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Column chart - show co...

Power Apps

Answered

Column chart - show columnby month in chart

(0) Share

Report

Report

Posted on by ITSYS

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))

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ITSYS 28 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation