How to sort columns in tablix and use backgroundcolor?

How to sort columns in tablix and use backgroundcolor?

Posted by: saumya on 5 March 2024, 8:50 am EST

• 

  saumya

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 March 2024, 8:50 am EST - Updated 5 March 2024, 8:55 am EST

  I am trying replicate a chart in AR. I am using tablix here reason being I have a column in my datasource as Rating (which has A, AA, AAA etc) and values as mkt value, so I need a table or pivot between rating and sector and sum them byt mkt values and then depending on the max and min sum values in my pivot table create a color scale with for example olive color where max is dark and min is transparent. You can also see the image attached for reference.

  

  1411×883 138 KB

  How to get min and max in data visualizer of background color cell and how to custom sort the columns like in order AAA, AA, A, etc ?

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2024, 5:26 pm EST

  Hi Saumya,

  We could observe this is a duplicate case for your case ID: CAS-47738-Z3C2X1, we have responded to the case itself.

  Please continue the case there itself to avoid any confusion.

  Thanks,
  
  Anand