Conditional formatting with up and down arrows

KB
New Contributor

Hi all,

I am trying to apply a conditional formatting to a variances column, if higher than last year then shown up arrow (color red) if lower than last year then down (color green).

Not sure how you can achieve this?

8 REPLIES 8

NicolasArgente
Valued Contributor

Hi KB, 

You will find it in the conditional formatting.

Thanks,

NicolasArgente_0-1663665611944.png

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

db_pdx
Contributor III

Hi KB: I don't know of a way to do arrows in a standard cube view.  The formatting options that would be most applicable for coloring in a Cube View would likely be:

  • TextColor
  • BackgroundColor
  • BorderColor
  • (+their Excel/Report equivalents)

You would set this in the Cube View > Rows and Columns > (select a report block) > Formatting > Cell Format.  Use a condition of If (CellAmount ... ) Then ...

Cheers    -DB

KB
New Contributor

I have done that with cell format as Wingdings but not sure what I need to include to return a text?

Kris
Contributor III

1. XFS Cube View Styles in Dashboard -> Parameters -> Conditional_Formatting

2. In Cube Attach this Formatting in the data Section and Make sure you select as Combo Box. so it will return as string.

3. You can use the conditional formation on the Amount Column and that should work. 

db_pdx
Contributor III

Can you share the content of your Conditional_Formatting parameter.  I'm not quite following how this is used.

Kris
Contributor III

Dashboard Parameters

Screenshot1.JPG

 

Cube View

Screenshot2.JPG

db_pdx
Contributor III

My bad, I understood that part.

What is the text/details of the 'Conditional_Formatting' parameter?  I assume that is where you have the conditional logic?

Kris
Contributor III

See below

Screenshot3.JPG

 

Screenshot4.JPG