cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bidax Frequent Visitor
Frequent Visitor

Conditional Formatting using SSAS Multidimensional as a Live Data Source

Hi all,

 

I am currently encountering a problem where conditional formatting does not seem to work.

 

Data source: SSAS 2016 Multidimensional cube

Connection type: Live (direct)

Power BI Desktop (Aug 2018 version)

 

Basically, I want to make negative values to have red coloured font, and postive values to have green font using table visual.

When I go to Conditional Formatting > Font Color, I choose "Format By" = Rules and set the conditions, but it does not work.

The colour did not change.

 

Is this a limitation of using SSAS MD Live connection?

Any ideas how I can make the conditional formatting work in this case?

 

Thanks

 

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: Conditional Formatting using SSAS Multidimensional as a Live Data Source

HI @bidax,

 

AFAIK, If you use multidimensional data source with live connection mode, it not support to create measure to enable conditional formatting features.

Connect to SSAS Multidimensional Models in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
bidax Frequent Visitor
Frequent Visitor

Re: 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..

Community Support Team
Community Support Team

Re: Conditional Formatting using SSAS Multidimensional as a Live Data Source

Hi @bidax,

 

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

17.png

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
bidax Frequent Visitor
Frequent Visitor

Re: Conditional Formatting using SSAS Multidimensional as a Live Data Source

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.

Community Support Team
Community Support Team

Re: Conditional Formatting using SSAS Multidimensional as a Live Data Source

Hi @bidax,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 313 members 3,227 guests
Please welcome our newest community members: