IF CONDITION FOR COLUMN CHART MARKER SUFFIX

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I tried the below condition, but its showing an error saying " expected text value", am not sure where am going wrong.

Am using this condition for a column chart marker suffix.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :

Do you want to add different MarkerDuffix to one column chart based on conditions?

Firstly,let me explain why you encounted this problem.

The point is data type.The MarkerDuffix property does not support Table.But The Value of ForAll(……) is a Table.

I think these links will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-column-line-chart

Secondly,I am afraid that it is impossible to add different MarkerDuffix to one column chart based on conditions.If you need this feature ,I sugget you consider submit your ideal on this forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft , thanks for making it clear, the marker property also doesn't support a table?

Another question, can we set the item color set of the column chart based on two series but display it as a single series by setting number of series to 1?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Anonymous :

Q1:

the marker property also doesn't ……

A:

The marker property only support true of false.

The MarkerSuffix property only support text.

Q2:

can we set the item color set ……

A:

Sorry I didn't understand what you mean. Besides, could you show me more detials?

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft i have a column chart with the same for all condition in item color set, i have date in labels & total hours in series1, this is to show the working hours, the blanks are nothing but leaves, instead of being blank i want to show it as a series in the column chart. I have a different column for leave values. Hope my 2nd question is clear now.
NOTE:I dont want to display two separate series in my chart.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :

Do you want to show only one series?

Could you show your data source?

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ v-bofeng-msft, below is the sample of my data source(sharepoint list)

Date Total working hrs Leave
10/11/20 8 0
10/12/20 8 0
10/13/20 7 0
10/14/20 0 8
10/15/20 0 8

8 hrs in leave indicates that they were on leave on that particular date, currently am showing only the total working hrs in my column chart i want to include leave as well with a different item color set

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @Anonymous :

If you only want to display the "Leave" series, you can set the chart's items property to

ShowColumns(YourDataSource,"Date","Leave")

If you want to create a stacked histogram,like this

I' afraid it is not available now.I think this link will help you a lot.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft , i want to show both leave & dailyhrs in single series, is it possible

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Anonymous :

If you want to put leave & Total work hrs in the same series, then you must transpose the data source table. But PowerApps currently does not have a transpose function, so you have to reconstruct the data source.For example:

Table( {Type:"Total working hrs",'10/11/20':LookUp(SPlist,Date="10/11/20").'Total working hrs','10/12/20':LookUp(SPlist,Date="10/12/20").'Total working hrs','10/13/20':LookUp(SPlist,Date="10/13/20").'Total working hrs','10/14/20':LookUp(SPlist,Date="10/14/20").'Total working hrs','10/15/20':LookUp(SPlist,Date="10/15/20").'Total working hrs'}, {Type:"Leave",'10/11/20':LookUp(SPlist,Date="10/11/20").Leave,'10/12/20':LookUp(SPlist,Date="10/12/20").Leave,'10/13/20':LookUp(SPlist,Date="10/13/20").Leave,'10/14/20':LookUp(SPlist,Date="10/14/20").Leave,'10/15/20':LookUp(SPlist,Date="10/15/20").Leave} )

But this is very troublesome, I don’t recommend you to do this.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft thanks for helping me out

Was this reply helpful? Yes No