Forum Discussion
Helper IIIMatrix visual - Formatting (rows format differently)
Hi DutchMark,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to FBergamaschi for those inputs on this thread.
Green underline not coming fully to the left this usually happens because the Matrix adds indentation when there are multiple fields in the Rows area. You can try turning off the Stepped layout under Row headers –> options and check if that makes the lines align properly.Bold only for “Total” rows At the moment, Power BI formatting applies bold to all rows or all subtotals. There isn’t a direct option to bold only “Total” rows. A workaround many people use is conditional formatting on the values for example, making font weight bold only if the row contains “Total”. That way you can highlight just those rows.
Right now there’s no one-click setting for this, so conditional formatting is the best way
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
Super UserIt is difficult to understand the issue not having the pbix
Anyway, please check in the format section of the matrix for "column headers" and check the alignment setting
Otherwise there might me some empty spaces in the other columns
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Helper IIIThe green line being not draw all the way to the left has nothing to do with alignment. You see a green line under each row for description WBS. A.I. also didn't know it. The pbix which I can not share nor simplify won't help. Maybe there is a workaround.
Also did read nothing about the totals.
v-hjannapuCommunity Support
Hi DutchMark,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to FBergamaschi for those inputs on this thread.
Green underline not coming fully to the left this usually happens because the Matrix adds indentation when there are multiple fields in the Rows area. You can try turning off the Stepped layout under Row headers –> options and check if that makes the lines align properly.Bold only for “Total” rows At the moment, Power BI formatting applies bold to all rows or all subtotals. There isn’t a direct option to bold only “Total” rows. A workaround many people use is conditional formatting on the values for example, making font weight bold only if the row contains “Total”. That way you can highlight just those rows.
Right now there’s no one-click setting for this, so conditional formatting is the best way
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.- DutchMark
"You can try turning off the Stepped layout under Row headers –> options and check if that makes the lines align properly." That has not been under this option for quite some time. It has been moved.
https://community.fabric.microsoft.com/t5/Desktop/stepped-layout-option-not-available-after-upload-to-shared-space/m-p/3921063#M1257917 - v-hjannapu
Hi DutchMark,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.- v-hjannapu
Hi DutchMark,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.