Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Remove bold from matrix row headers

Good morning everyone. I am creating a matrix related to the projects developed by people on my team. One thing that bothers me is the fact that when I open a hierarchy, ALL THE ROW HEADERS ARE IN BOLD. Is there any way to remove this? Make only the selected level bold, and not all the others that were not selected?

 

extra: Another thing: Is there a way to gradually change the background color from the second level of the hierarchy? Example: The first level is white, but the second level becomes more gray, and the third level even more gray? Thanks!

 

Need Help
Show and Tell
  • severynm's avatar
    severynm
    8 months ago

    So it turns out this is indeed possible. Toggle on 'Row subtotals' and adjust their styling from the 'Values' section. Ensure the 'Apply to labels' toggle is checked here. Then you can go back and turn off the Row subtotals, if necessary.

     

    Source: Un-Bold Row Headers

4 Replies

  • severynm's avatar
    severynm
    Advocate I
    8 months ago

    So it turns out this is indeed possible. Toggle on 'Row subtotals' and adjust their styling from the 'Values' section. Ensure the 'Apply to labels' toggle is checked here. Then you can go back and turn off the Row subtotals, if necessary.

     

    Source: Un-Bold Row Headers

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    You can only influence the font weight of the second and further levels, and you cannot influence the colors on individual levels.

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,

    Thanks for the solution lbendlin  offered, and i want to offer some more infotmation for user to refer to.

    hello Anonymous , as lbendlin mentioned, you cannnot remove the bold font, this is how Power BI is designed, and there is no way to change it. and based on your description, you can not change the color in hierachy in header directly, if you want to change the color , you can set the background of the value, you can refer to the following sample.

    Create a measure.

    MEASURE =
IF (
    ISINSCOPE ( 'Table'[Third level] ),
    "#5D5C5B",
    IF ( ISINSCOPE ( 'Table'[Second level] ), "grey", "white" )
)

    Create a matrix,and put the following field to the matrix.

    Then put the measure to the conditional formatting of the value.

     

    Output

    (Note:This conditional formatting is only valid for the current hierarchy. When you expand to the next hierarchy, the color of the previous hierarchy will become white by default.)

     

    Best Regards!

    Yolo Zhu

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