Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
Accepted

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

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.

Reports

8 Comments

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous, 

     

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

     

    Best Regards,
    Qiuyun Yu 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-qiuyu-msft 

    Starting MatrixExpanded with +/-Collapsed with hierarchy

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
    HadBen
    Frequent Visitor
    6 years ago

    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's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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/

Completed Ideas