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