Matrix Visualization Column Formatting

[nripendrasinha]

I ma using Matrix Visualization as shown below

I would like to achieve two things:

1. The Avg Supplier Cost (Local) is showing as a sub column and each main column and its repeating under every main column

I want the Avg Supplier Cost (local) Column to be a separate independent column so that it doesnt repeat under each main column

2. Have a conditional formatting for Approval Status Column, such that it shows Green color as background if the status is "Done" and "Actual Due Date" is less than or same as Planned Due date. And based on the same condistion it should show Green Tick as an icon

If the Approval status is "Done" but Actual Due date is more than Planned Due date then the Background color must be Yellow and it should show a Exclamation beside "Done"

If the Approval status is "Open" and Actual Date is more than Planned Due Date then the Background color must show Red and a "?" as Icon

[Anonymous · Accepted solution]

Hi @Prabhu_PowerBI ,

Just like @danextian said, colum header formatting on matrix is currently not supported.

However, you can set the background color and icons of cells. I have created a sample data: 

1.Add a new measure:

color =
IF (
    SELECTEDVALUE ( 'Table'[Sales] ) > 60
        && SELECTEDVALUE ( 'Table'[Date] ) < DATE ( 2023, 3, 15 ),
    "yellow",
    "green"
)

 2.Put into Background color.

3.Set icon.

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more qui

[danextian]

Hi @nripendrasinha ,

Colum header formatting on matrix is currently not supported. I've read somewhere that is in the roadmap or I could be wrong.