Un-Bold Row Headers

Have you ever created a matrix visual, with hierarchy, where your row headers are formatted 𝐛𝐨𝐥𝐝?

You can not seem to turn if off, because turning off the 𝐛𝐨𝐥𝐝 formatting in both the section 𝐯𝐚𝐥𝐮𝐞𝐬 and 𝐫𝐨𝐰 𝐡𝐞𝐚𝐝𝐞𝐫𝐬 does not seem to work?

This is because the option to turn of 𝐛𝐨𝐥𝐝 formatting for row headers is actually in the section 𝐫𝐨𝐰 𝐬𝐮𝐛𝐭𝐨𝐭𝐚𝐥𝐬.

Navigate to the format pane, turn on the section 𝐫𝐨𝐰 𝐬𝐮𝐛𝐭𝐨𝐭𝐚𝐥𝐬, go to 𝐯𝐚𝐥𝐮𝐞𝐬, uncheck 𝐛𝐨𝐥𝐝 and make sure that the option 𝐚𝐩𝐩𝐥𝐲 𝐭𝐨 𝐥𝐚𝐛𝐞𝐥𝐬 is turned on. It will then 𝐮𝐧-𝐛𝐨𝐥𝐝 your row headers.

Sharing is caring!

Have a look at my other blogs

ISFILTERED

You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that if you add multiple ISFILTEREDs together, ISFILTERED will not return true or false, but will return a number. You can combine this returned number with a switch function to influence your total levels.

Alignment of visuals

Have you ever heard of the “Align” button? It helps you to align visuals, no more precision drag-and-drop…

It also helps to distribute visuals horizontally of vertically over a canvas. This will give an overall alignment of visuals which would make your report so much cleaner.

Why you want to avoid a many-to-many relationship?

The Power BI data model is one of the most important aspects of a good Power BI environment. The data model is the way Power