cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbityro Regular Visitor
Regular Visitor

column textcolor

hi all,

i have a table with monday, tuesday and so on...

saturday and sunday i want in red and cursive...

how can i realise that?

 

what not works is:

WeekdayColor = SWITCH(TRUE();
                            table[weekday]="Saturday"; "Decline"
)

 

6 REPLIES 6
tex628 New Contributor
New Contributor

Re: column textcolor

If you create each weekday as seperate measures and use in a matrix you can field format only the header to red text:
image.png
This will only work if you use a seperate measures for each day and i don't actually think there is any other way to do it. 

powerbityro Regular Visitor
Regular Visitor

Re: column textcolor

hi tex... many thanks for your reply

but what do you mean with seperate measueres? do i have than one column at the end?

i use a table, not a matrix

powerbityro Regular Visitor
Regular Visitor

Re: column textcolor

i have a column like that

 

weekday

monday

monday

tuesday

saturday

tex628 New Contributor
New Contributor

Re: column textcolor

Ohh, in that case it might not be any issue. 

In a matrix you would generally have a day dimension as the column. Which would automatically give you the weekdays as columns. This would mean that you can individually field format a column, as all the different says were just part of the day dimension. 

But if you have a table, i assume you have measures similar to:

Monday = Calculate( SUM( [Amount] ) , [Weekday] = "Monday" )


If you do, all you need to do is go into the pane for field formatting and format sunday/saturday

powerbityro Regular Visitor
Regular Visitor

Re: column textcolor

with field formatting it is only possible to color all values in a column... not only saturday and sunday 😕

tex628 New Contributor
New Contributor

Re: column textcolor

Then you have the days as rows and not columns. It's not possible to color the headers of specific rows. 

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,856)