Answered

Column chart - show columnby month in chart

(0) Share

Report

Posted on by ITSYS

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

Answers (1)

Sort by

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