cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

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.

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors