Forum Discussion
Conditional Formatting using SSAS Multidimensional as a Live Data Source
I dont plan to create a new measure, but using the fields from the cube directly and want to format the font color, but it does not seem to work either.
Limitation or I just dont know how to do it..
Hi Anonymous,
>>I dont plan to create a new measure, but using the fields from the cube directly and want to format the font color, but it does not seem to work either.
In fact, I can setup conditional formatting on existed fields from SSAS live connection datasource.
Regards,
Xiaoxin Sheng
Ah yes, I noticed this - the conditional formatting works for detailed data points only, not including the Total value.
In my case, I just want to show the Total, but the conditional formatting does not work.
Btw, I just want to show the Total as a workaround because Card visual does not have Conditional Formatting at all.
Hi Anonymous,
AFAIK, current full conditional formatting features only works on table and matrix. Some of charts allow you to setup advanced color control on data color option to achieve similar bar color conditional formatting.
For enable conditional formatting on specific level, I think you need to add condition to check current level and set up result color on specific summarize level, other result replace to normal color.
Regards,
Xiaoxin Sheng