☝️Small business or a startup? See if you qualify for our special offer.
+

Requesting support for font and colour formatting in custom mdx columns

Answered
Yosef asked 1 day ago

Flexmonster has a mdx configuration which supports defining a with member clause to add additional custom measures to the report. It doesn't support font and colour formatting native to mdx. Can you consider adding support for font and colour formatting directly in mdx?

Here's an example we use to style the format based on a value scale:

with member [Measures].[SP Benefit Ratio1] as 
     IIF([Measures].[SP Total] = 0, null, [Measures].[SP Total Benefits] / [Measures].[SP Total]), 
   BACK_COLOR=IIF([Measures].[SP Benefit Ratio]>0.40,RGB(255,0,0), RGB(0,255,0)),
   FONT_NAME="High Benefits", FONT_SIZE=24, 
   FORMAT_STRING="#,0.00%;-#,0.00%" 
   select ({[Measures].[SP Benefit Ratio1]}) on columns, 
   (TOPCOUNT([Staffing Pattern - Fact].[Division Display Name].ALLMEMBERS,5,[Measures].[SP Benefit Ratio1])) on rows from [Model]  
   where ({[Year - Filter].[Year].&[2025]}) 
   CELL PROPERTIES VALUE, FORMATTED_VALUE, FORE_COLOR, BACK_COLOR, FONT_SIZE

 

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 14 hours ago

Hello, Yosef!

Thank you for reaching out to us.

Kindly note that in Flexmonster, it is not possible to add text styling via MDX.
Alternatively, there are possible approaches to change font color and size:

Hope you will find our answer helpful.

Kind regards,
Solomiia

Please login or Register to Submit Answer