Forum Discussion
Responsive ResidentHelp me with matrix visual requirements ?
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 ?
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:- Add a new column in your data source to define the custom sort order (e.g., Sort Order).
- 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.
11 Replies
v-aatheequeCommunity Support
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:- Add a new column in your data source to define the custom sort order (e.g., Sort Order).
- 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.
LaxmanjatothResolver I
i also told him same , lets wait for reply
- danextian
Super User
There is currently no option to conditionally format row or column categories. You can conditionally format the values instead but without bold.
- 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
- Greg_Deckler
Community Champion
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.
- 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
ashmitp869Yes thanks for the Sort Order 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!
