column textcolor

[powerbityro]

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"

)

[tex628]

If you create each weekday as seperate measures and use in a matrix you can field format only the header to red text:

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]

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

[tex628]

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]

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

[tex628]

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

[powerbityro]

i have a column like that

weekday

monday

monday

tuesday

saturday