Power Platform Community Forum Thread Details

Hey Power Guys,

Am still trying to figuer out the charts in PowerApps, i have a table that looks like this:

Etablishment	Category	Purchase	Income
Carrefour	Food	500
Darty	Appliance	12000
Client	IT		1500

How can i display in a column chart the Purchase and income with label the category?

i have tried this but it show the total of income and the purchase,

With(
 {wList: Add_Expensive},
 Table(
 {
 Income: Sum(
 Filter(
 wList,
 Text(
 DateOf,
 "mmmm"
 ) = '(GRP_FILT)DRP_Filter-Month_Main_Screen'.Selected.Value && Year(DateOf) = '(GRP_FILT)DRP_Filter-Year_Main_Screen'.Selected.Value
 ),
 Income
 ),
 Pur: Sum(
 Filter(
 wList,
 Text(
 DateOf,
 "mmmm"
 ) = '(GRP_FILT)DRP_Filter-Month_Main_Screen'.Selected.Value && Year(DateOf) = '(GRP_FILT)DRP_Filter-Year_Main_Screen'.Selected.Value
 ),
 Purchase
 ),
 Etablistment:
 LookUp(
 wList,
 Text(
 DateOf,
 "mmmm"
 ) = '(GRP_FILT)DRP_Filter-Month_Main_Screen'.Selected.Value && Year(DateOf) = '(GRP_FILT)DRP_Filter-Year_Main_Screen'.Selected.Value
 ,
 Category
 )
 }
 )
)

Categories:

Building Power Apps