Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
Solved! Go to Solution.
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())
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())
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 20 | |
| 11 |
| User | Count |
|---|---|
| 62 | |
| 55 | |
| 47 | |
| 44 | |
| 37 |