Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Format ( Gray out /disable) the entire Table row based on a condition

Hello,

 

How do I Format ( Gray out /disable) the entire Table row based on a condition? The row and values must be visible.

Hint: https://community.powerbi.com/t5/Service/Color-row-based-on-date-condition/td-p/161638

Thanks

Alan Jacob

  • Hi Anonymous 

    As this is a question with the core table visual rather than about custom visuals, you might be better asking in the Desktop or DAX forums, as these are much more heavily frequented and people who might be able to answer more quickly.

    To help you on your way, it's not possible to disable a row, but it could be coloured differently if a condition is met. If you follow the guide on conditional formatting, specifically the section on formatting by field value, then this can be done. Please bear in mind that you will need to apply the formatting rule to each column (field) of the table.

    I hope this helps,

    Daniel

1 Reply

  • dm-p's avatar
    dm-p
    Icon for Super User rankSuper User

    Hi Anonymous 

    As this is a question with the core table visual rather than about custom visuals, you might be better asking in the Desktop or DAX forums, as these are much more heavily frequented and people who might be able to answer more quickly.

    To help you on your way, it's not possible to disable a row, but it could be coloured differently if a condition is met. If you follow the guide on conditional formatting, specifically the section on formatting by field value, then this can be done. Please bear in mind that you will need to apply the formatting rule to each column (field) of the table.

    I hope this helps,

    Daniel