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 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
    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 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
    DjeffersonMorais Morais profile image

    DjeffersonMorais Morais on 7/27/2023 4:23:00 PM

    Power BI

    Add Conditional Formatting options to Matrix Viz for Row Headers

    Subject: Applying Conditional Formatting to Matrix Rows for Hyperlinks


    Hi,

    I hope this email finds you well. I am reaching out regarding a task I'm currently working on and could use some guidance or improvement suggestions.


    I am trying to apply conditional formatting to the rows in a matrix to create hyperlinks for the values in the row headers. The idea is to make the row headers clickable, leading to web links associated with each row.


    My main concern is whether it is possible to add the same functionality we have when selecting values in a matrix to the row headers. Ideally, I'd like users to be able to click on a row header and have it redirect them to the corresponding hyperlink.


    If you have any insights or know of a way to achieve this, I would greatly appreciate your assistance. Additionally, if you think there is a better approach or any improvements to my current plan, please don't hesitate to share your suggestions.


    Looking forward to your response.


    Best regards,


    Djefferson Morais







    New
    Vote 15
    Prasad Babu Konduru profile image

    Prasad Babu Konduru on 12/3/2020 7:26:13 AM

    Power BI

    Conditional Formatting enable for Rows of the Matrix, And also for values inside Slicers.

    Please Enabling the Conditional Formatting for Rows in the matrix. Which enables the First column fixed and we can do some Conditional formatting on that column simultaneously. And also Enabling Conditional Formatting for Values Inside slicers.

    Needs Votes
    Vote 8
    Vitor Joia Aires profile image

    Vitor Joia Aires on 2/9/2021 10:30:38 AM

    Power BI

    Creating conditional formatting for each matrix column

    I would suggest to create a way in order to make conditional formatting for each column of the matrix. Currently, there is only the possibility of making conditional formatting for the table as a whole, without partitioning the same conditionals for each column or row.

    Needs Votes
    Vote 207
    Simran Tuli profile image

    Simran Tuli on 8/10/2020 3:49:11 AM

    Power BI

    Conditional Formatting of Row Headers in Matrix

    Please vote for this idea if you also want to be able to conditionally format the row headers in a matrix.

    Needs Votes
    Vote 8
    Sean McLarty profile image

    Sean McLarty on 1/17/2019 6:13:42 AM

    Power BI

    Keep conditional formatting in a matrix's parent rows when it's child rows are expanded

    When you expand a level in a matrix using +/- buttons only the very lowest level keeps its conditional formatting (including data bars) - all parent levels lose their conditional formatting. I'd like the option to keep conditional formatting for parent rows regardless of whether child rows are expanded.

    Needs Votes
    Vote 69
    Guillaume Vissian profile image

    Guillaume Vissian on 1/16/2019 7:52:31 PM

    Power BI

    conditional formatting

    Conditional formatting for matrix and tables headers To have context dependant row & column headers background and text colors is something that would be very nice for user contextualisation

    Needs Votes