Forum Discussion

Hugo999's avatar
Hugo999
Frequent Visitor
1 year ago
Solved

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. 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())

1 Reply

    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())