News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Count ColumnChart

Power Apps - Building Power Apps

Unanswered

Count ColumnChart

(0) Share

Report

Report

Posted on by MiniMax92

151

Hey ho,

i need a "ColumnChart" with singel datas.

My formular is:

CountA( Table( Distinct(SharepointList;Location)))

But it is underline in Red with failure massage: "Table Value needed"

Heeelp :D

Categories:

Using Apps Using Formulas

All responses Img

All responses (4)

Answers Img

Answers (0)

MiniMax92 151 on at

Like (0)

Report

Count ColumnChart

Hey,
Yes. The Formular is in Items and your Formular is the same result with no Chart :(
AhmedSalih 6,678 Super User 2025 Season 1 on at

Like (0)

Report
Count ColumnChart

Hello, Distinct function return a table with one column. Have you tried to use only the distinct function with the Table function?

CountA(Distinct(SharepointList;Location))
MiniMax92 151 on at

Like (0)

Report

Count ColumnChart

Thx for your reply,

i try it but now I no longer have an error message, but no columns are displayed. Although there is data in the column. The aim is to count how many are in Location 1 and how many are in Location 2 and so on. And Distinct filters the same locations, that works great too but somehow it doesn't count them.

As you can see in the picture, the names also overlap with each other.
D_D 107 on at

Like (0)

Report

Count ColumnChart

Hi,

do you try to use the Formula as your Items of the Column Chart?
CountA returns a number, but you need to pass a table as items. This is what the failure message says.
You can try Items = Table(Distinct(SharepointList;Location)) and view the resulting chart.

--------------------------------------------------------------------------------------
If this helps you or solved your question, please like or mark this as an answer.
Best regards, David