Help me with matrix visual requirements ?

[ashmitp869]

Spoiler

Hi,

Can I move the Cost Category - Fees at the buttom. Now its sorted alphabetically

Is there any way I can change the Color of only Fees to Green and make it BOLD ?

[Laxmanjatoth]

A caluclated column with the formula column = if (cost Catergory =" Allowance",1,If cost Catergory = "Fees,"2, if(cost Catergory=''fOM",3, Similarly, you can build the remaining categories and enter numbers according to the category.

sort this cost Catergory column with caluculated column

everything is set

[ashmitp869]

Yes thanks for the Sort Order solution.

[Laxmanjatoth]

please accept the solution 

[v-aatheeque]

Hi @ashmitp869 ,

Glad that your query got resolved and If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque · Accepted solution]

Hi @ashmitp869 

Thanks for reaching out to the Microsoft Fabric Community forum.

@danextian @Greg_Deckler @lbendlin  Thank you for the prompt response!
In addition, To @danextian @Greg_Deckler @lbendlin   ,please allow me to provide another insight: 
To address your query regarding customizing the order of the "Cost Category" and moving "Fees" to the bottom, here’s how you can achieve it:

1. Add a new column in your data source to define the custom sort order (e.g., Sort Order).
2. Assign numerical values to each category based on the desired order, ensuring "Fees" is given the highest value so it appears at the bottom.

Using this approach, the table order is adjusted as expected. Below is a screenshot demonstrating the results:

NOTE : For specific rows there is no possibility of applying conditional formatting.

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

[Laxmanjatoth]

i also told him same , lets wait for  reply 

[danextian]

There is currently no option to conditionally format row or column categories. You can conditionally format the values instead but without bold.

[lbendlin]

Theoretically you can use SVG to embolden individual cells, but it's a lot of effort.

[danextian]

Did that with some personal projects but it was a lot of effort plus the exported data has the SVG codes instead of the actual values.

[Greg_Deckler]

@ashmitp869 99.999% certain the answer is "no" for a matrix visual. There are basically no individual or conditional formatting for row headers or column headers.

[lbendlin]

Read about "Sort a column by another column"

Is there any way I can change the Color of only Fees to Green and make it BOLD ?

not really.  If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com