The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to Solution.
Hi,
Thanks for the solution lbendlin offered, and i want to offer some more infotmation for user to refer to.
hello @mh_vasconcelos , 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.
Hi,
Thanks for the solution lbendlin offered, and i want to offer some more infotmation for user to refer to.
hello @mh_vasconcelos , 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.
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