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: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Matrix conditional formatting issue with the +/- buttons and the visual header buttons

Submitted by Anonymous on ‎05-08-2019 02:43 AM

If you have a matrix with a hierarchy on the rows and have both the +/- buttons enabled and the visual header hierarchy navigation buttons showing it is possible for the user to break the conditional formating.

 

If you have a matrix where there is conditional formatting applied to both the top level and bottom level of the hierarchy and you navigate the hierarchy exclusivly with either the +/- buttons or the visual header the conditional formatting works as expected. If you navigate down it removes it from the top level and if you navigate back up it reapplies to the top level again.

 

However if you navigate with a mixture of the two methods such as expand the hierarchy with the visual header and then go back up with the +/- buttons the top level will remain bold and the conditional formatting will not reapply.

Status: Accepted
See more ideas labeled with:
8 Comments (8 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-09-2019 12:09 AM

Hi @Anonymous, 

 

Would you please share some screenshots to clarify the issue? Please do mask sensitive information before uploading. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎05-09-2019 07:06 AM

@v-qiuyu-msft 

Starting MatrixStarting MatrixExpanded with +/-Expanded with +/-Collapsed with hierarchyCollapsed with hierarchy

v-qiuyu-msft
Community Support
Community Support
‎05-10-2019 02:53 AM

Hi @Anonymous, 

 

I have reported this issue internally: CRI 119560298. Will update here once I get any information. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Community Support
‎05-10-2019 02:54 AM
Status changed to: Accepted
 
v-qiuyu-msft
Community Support
Community Support
‎05-14-2019 02:12 AM

Hi @Anonymous, 

 

I got information below internally:  

 

"This is the expected behavior, as noted in other previous CRIs.

Only the most-granular level of data receives Conditional Formatting.

Any collapsed node (Node showing + button and having bold text) is a Subtotal, and thus can't have Conditional Formatting.

When the user presses "-" to collapse, they are not "navigating" to the first level, they are just collapsing a node.

Navigating to the first level is done by drill up or Right click -> Collapse level"

 

Best Regards,
Qiuyun Yu 

HadBen
Frequent Visitor
‎06-16-2020 02:09 AM

Would it be possible to fix this issue? When opening only one column via the +/- bar the table looks completely different, and far uglier than it does without partial collapsing. 

Anonymous
Not applicable
‎08-04-2020 06:14 PM

I've just come to grief on this issue as well. Any hint on the ETA for the fix? 

v-diye-msft
Community Support
Community Support
‎08-21-2020 01:47 AM

Hi all,

 

We got the feedback from PG :

This is the expected behavior, as noted in other previous CRIs.

Only the most-granular level of data receives Conditional Formatting.

Any collapsed node (Node showing + button and having bold text) is a Subtotal, and thus can't have Conditional Formatting.

When the user presses "-" to collapse, they are not "navigating" to the first level, they are just collapsing a node.

Navigating to the first level is done by drill up or Right click -> Collapse level

 

The behavior is documented.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/

Idea Statuses