Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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 |
|---|---|
| 58 | |
| 44 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 44 | |
| 24 | |
| 22 |