cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
veng2002 Frequent Visitor
Frequent Visitor

Conditional formatting based on column

Hi, 

I built my matrix with columns as each day of the month and also the two priorities I'm working with (P1 and P2).

And I have two problems:

1) Since I have each day of the week and two priorities, each day has two columns below...

2) I get a 0 value written when the value in the adjacent column is 1 or more.

MatrixHelp.pngCurrent scenario

 

What I want to approach and can't think of, is:

1) not get a zero when the value next to it is +1 or 1.

2) avoid having the two priorities there  resulting on each day with two columns (removing on of the priorities is not the answer, sorry 😞 ) As you can see from the sample data, if I have a P2 I dont have a P1 and VS.

On my ideal world, I would have the column of the day, and if I have a P2 it will be yellow, and If I get a P1 it'll be red. Any ideas on how this could be done?

Thanks in advanced!

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Conditional formatting based on column

Hi @veng2002,

 

1) not get a zero when the value next to it is +1 or 1.

 

Which value do you use drag to matrix value? I guess the o value in the matrix from the table. If possible, please share some sample data. 

 

2) avoid having the two priorities there  resulting on each day with two columns (removing on of the priorities is not the answer, sorry Smiley Sad ) As you can see from the sample data, if I have a P2 I dont have a P1 and VS.

On my ideal world, I would have the column of the day, and if I have a P2 it will be yellow, and If I get a P1 it'll be red. Any ideas on how this could be done?

 

Conditional Formatting can be used for field or measure you place on the Matrix Values section, it can't be used based on column or row group. 

 

Best Regards,
Qiuyun Yu 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)