cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RichardJ
Resolver III
Resolver III

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
VasTg
Memorable Member
Memorable Member

@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

SteveCampbell
Memorable Member
Memorable Member

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  
Read my blogs on  



View solution in original post

2 REPLIES 2
SteveCampbell
Memorable Member
Memorable Member

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  
Read my blogs on  



View solution in original post

VasTg
Memorable Member
Memorable Member

@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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors