Forum Discussion

powerbityro's avatar
powerbityro
Helper II
7 years ago

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"
)

 

Need Help

6 Replies

  • tex628's avatar
    tex628
    Community Champion
    7 years ago

    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's avatar
      powerbityro
      Helper II
      7 years ago

      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's avatar
        tex628
        Community Champion
        7 years ago

        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