Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Can't use conditional formatting with Azure Analysis Services

I got model by live connect to Azure Analysis Services Database, then I can't choose any column or measure for field value when use conditional formating, which is available with SSAS or PBI Dataset.

Why this is not available with Azure Analysis Services? 

Are there any solution for this case?

Thank you very much for your help.

QuinnDatatyk_0-1658723293741.png

 

Status: Investigating

Conditional formatting needs an aggregation or measure to be applied to the value. That's why you see 'First' or 'Last' in the Color by value example. If you're building your report against an Analysis Service multidimensional cube, you won't be able to use an attribute for conditional formatting unless the cube owner has built a measure that provides the value.

 

See: Apply conditional formatting in tables and matrixes 

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Investigating

Conditional formatting needs an aggregation or measure to be applied to the value. That's why you see 'First' or 'Last' in the Color by value example. If you're building your report against an Analysis Service multidimensional cube, you won't be able to use an attribute for conditional formatting unless the cube owner has built a measure that provides the value.

 

See: Apply conditional formatting in tables and matrixes 

 

Best Regards,
Community Support Team _ Yingjie Li