Matrix visual - Formatting (rows format differently)

[DutchMark]

Hello,

I have 3 rows in my Matrix, only one is formatted differently, however I did not do that. My "Description WBS" column is formatted as I want and formatted exactly the same as my value columns. Why does the green line doesn't get formatted all the way to the left? How can I change that?

Also I want to format my rows with "Total" in Bold, however if I try that under Rowsubtotals and than Values, everything gets formatted in bold, also the "normal" rows. 

[FBergamaschi]

It 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

[DutchMark]

The 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-hjannapu · Accepted solution]

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-t...

[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.

[DutchMark]

I will review later

[v-hjannapu]

Hi @DutchMark,
Could you please let us know the ETA by when you will be able to test the provided solution? This will help us to know when we can follow up. If you encounter any challenges during implementing the provided solution, please inform us and we’ll be glad to assist.

Regards,
Harshitha.

[DutchMark]

Being this pushing is not okay, it's annoying. I will review it when I review it. 

[v-hjannapu]

Hi @DutchMark,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.