Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

QuinnDatatyk

Can't use conditional formatting with Azure Analysis Services

Submitted by on ‎07-24-2022 09:38 PM

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

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎07-25-2022 06:57 PM
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

Idea Statuses