Skip to main content
Search

    Search Microsoft Fabric Ideas

    Vote 50
    Kenneth Martin profile image

    Kenneth Martin on 10/8/2021 2:38:54 PM

    Power BI

    Matrix Conditional Formatting for Rows

    Is there a way to add in conditional formatting on rows in a Matrix. Right now, you can only do that for values and not for matrix.

    New
    Vote 23
    Sean.M Ryan profile image

    Sean.M Ryan on 6/21/2021 1:44:43 PM

    Power BI

    Column Conditional Formatting in a Matrix

    Ability to format column headers in a matrix similar to the conditional Field Format

    Needs Votes
    Vote 247
    EYMARD profile image

    EYMARD on 7/21/2016 8:57:13 PM

    Power BI

    conditional formatting in matrix

    I need to have the possibility to add conditional formatting in Matrix chart as we can do in Cross table in Excel. Thanks

    Completed

    Administrator

    We've added support for conditional formatting on the matrix visual in the November release of Power BI Desktop. To learn more, check out our blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/

    Vote 35
    Kathryn Egan profile image

    Kathryn Egan on 4/29/2019 11:29:57 PM

    Power BI

    Conditional Formatting for Matrix Headers

    To be able to set separate column header (and whole columns) backgrounds in a matrix to a specific color based on its value (Same as conditional formatting of values by field value) for multi-column tables.

    Needs Votes
    Vote 3
    Anazraf Irhas profile image

    Anazraf Irhas on 2/6/2024 4:19:40 AM

    Power BI

    Conditional Formatting on Matrix Table

    Dear Power BI Developer team, I would appreciate if you could provide conditional formatting for rows and column of matrix table. Especially on when we have several column included as column headers, we may want to highlight one of the key columns data. Hope you could consider that for the next update.

    New
    Vote 2
    André profile image

    André on 1/28/2020 2:51:28 AM

    Power BI

    Traffic light as conditional formatting for matrix

    Add new options inside the conditional formatting for matrix, as traffic light. Today there are only two options background color or bar. Symbols such as traffic light, arrows, stars, etc, would help the customization of the matrix.

    Needs Votes
    Vote 7
    Ajay RATHORE profile image

    Ajay RATHORE on 9/15/2023 10:57:36 AM

    Power BI

    Conditional formatting for Matrix row header

    Hi Team,

    In Power BI Matrix, there is one simple feature missing and I am getting lots of requirement for rows of matrix with conditional formatting with different color.

    can you pls introduced this feature in your upcoming update.

    thanks


    New
    Vote 12
    Michael Hutchinson profile image

    Michael Hutchinson on 9/11/2019 8:50:14 PM

    Power BI

    Conditional formatting for matrix subtotal labels

    Addition of conditional formatting for matrix subtotal labels similar to title text.

    Needs Votes
    Vote 31
    José Pintor profile image

    José Pintor on 9/12/2017 3:46:01 PM

    Power BI

    Conditional Formatting for Total and Subtotals in Matrices

    The ability of conditional formatting in matrices for values is wonderful. However, it would be great to have the ability to format subtotals and totals also, as the variation on those fields are often even more important to draw attention to.

    Needs Votes
    Vote 283
    Power BI User profile image

    Power BI User on 11/16/2017 10:01:19 PM

    Power BI

    Matrix: conditional formatting per row in matrix

    Currently, conditional formatting in matrix is based on all values of the matrix. I am looking forward to have it based on individual rows (a feature already available in Excel) Consider having monthly data (column) which you want to track for multiple categories (rows). But the categories have completely different values (i.e. some rows with $10 on average and some rows with $1000 on average). By applying conditional formatting per row, you can track trends/behaviour per individual category. Now the row with the highest values ($1000 row in above example) will typically steal all the highlights, and not allow you to see any color changes in rows which have much lower values (yet can still have trends) The only current "trick" is to transform the data as a percentage of row total (%). However, then you can still face problems if you have some outliers in a specific row.

    Needs Votes