Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Hugo999
Frequent Visitor

Matrix Visualisation: Border specific column?

Dears

Version July 2024
I want a border around a specific column in a matrix visualization. Is this possible in version July 2024?

tnx for your help

1 ACCEPTED SOLUTION
Laxmanjatoth
Resolver I
Resolver I

  1. Try this once , if not workout , we cont do anything 

     

    One way to make a column stand out is to use conditional formatting to add a background color to the entire column. This won't exactly give you a border, but it can visually highlight the column.

    Select the Matrix Visual.
    Go to the Format Pane.
    Under Conditional Formatting, choose the column you want to highlight.
    Set a background color that contrasts with the rest of your matrix. You can use a formula to apply a color dynamically depending on your data.
    Workaround 2: Using DAX for Custom Columns
    Another option is to create a custom column in DAX that is used only for visualization purposes. This column can then be formatted to create the appearance of a border. For example, you can use a DAX expression to create a column that contains a special character (like "###") to create a pseudo-border effect.
    Example DAX formula:
    DAX 
    BorderColumn = IF([YourCondition], "###", BLANK())

View solution in original post

1 REPLY 1
Laxmanjatoth
Resolver I
Resolver I

  1. Try this once , if not workout , we cont do anything 

     

    One way to make a column stand out is to use conditional formatting to add a background color to the entire column. This won't exactly give you a border, but it can visually highlight the column.

    Select the Matrix Visual.
    Go to the Format Pane.
    Under Conditional Formatting, choose the column you want to highlight.
    Set a background color that contrasts with the rest of your matrix. You can use a formula to apply a color dynamically depending on your data.
    Workaround 2: Using DAX for Custom Columns
    Another option is to create a custom column in DAX that is used only for visualization purposes. This column can then be formatted to create the appearance of a border. For example, you can use a DAX expression to create a column that contains a special character (like "###") to create a pseudo-border effect.
    Example DAX formula:
    DAX 
    BorderColumn = IF([YourCondition], "###", BLANK())

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.