cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RichardJ Advocate I
Advocate I

Icons disapper from matrix during expand(+)

Hi,

I would like to use a Red/Amber/Green tracker to track project status over time.

(Shame it wasn't Red/Yellow/Green but thats another story!)

 

The raw data has a Status field which has the text values of Red, Amber or Green.

To be able to conditionally format an icon into the Status field; upon import of the data a column is added to the table with the values as shown

 

If Text = Red then the Status Column will be 25%

If Text = Amber then the Status Column will be = 50%

If Text = Green then the Status Column will be = 75%

 

which enables the following conditional formatting rules to be applied

 

Icon_Creation.JPG

 

This works and displays the icons in a matrix as shown:

 

Matrix_No_Expand.PNG

 

 

 

 

 

 

 

 

However, when + sign is used to expand the content of a section the icons appear ok for the expanded section but no longer appear for the remainder of the matrix which displays the numerical values instead of the icons.

Matrix_Expanded.PNG

 

Has anyone else seen this behaviour (i.e. losing the conditional formating of the icons upon expansion of a matrix section) and is there a way to display the icons rather than the numbers.

 

Thanks,

Richard

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
Super User I

Re: Icons disapper from matrix during expand(+)

@RichardJ 

 

The conditional format only works for the most granular data.

 

Refer to this post.

 

https://community.powerbi.com/t5/Issues/Matrix-conditional-formatting-issue-with-the-buttons-and-the...

 

If this helps, mark it as a solution

Kudos are nice too.

Connect on LinkedIn

View solution in original post

Super User I
Super User I

Re: Icons disapper from matrix during expand(+)

Unfortunately, you cannot apply to headers and tows. You can vote for the idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: Icons disapper from matrix during expand(+)

@RichardJ 

 

The conditional format only works for the most granular data.

 

Refer to this post.

 

https://community.powerbi.com/t5/Issues/Matrix-conditional-formatting-issue-with-the-buttons-and-the...

 

If this helps, mark it as a solution

Kudos are nice too.

Connect on LinkedIn

View solution in original post

Super User I
Super User I

Re: Icons disapper from matrix during expand(+)

Unfortunately, you cannot apply to headers and tows. You can vote for the idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-f...

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors