How can we help?
< All Topics
Print

Using the category placeholder

With the category placeholder, you can add a dimension to the visual and have it show the result of your measure for multiple elements. There are endless ways how this can make your report more informative.

 

The basic way is shown in the bottom left corner of the report below where we simply make the name of the country bold, add some text and then show the variance between Actuals and Budget. The more advanced way is shown on the right where we also load the flag of each country from an online source and dynamically format the values green or red. Please note that because we are loading the flags from an online source, this functionality is only available for the HTML VizCreator Flex visual.

In This article, we will focus on the basics but you can download the sample file where the DAX and HTML code for the more advanced option is described.

This technique can be used to create tables or visuals which are simply not possible to do with native Power BI functionality.

What you need to make this work

 

First, you need to have a measure that shows a result for the dimension you later want to add to the category placeholder. In our sample, the category by which we want to split is the Country from the Data table. So we create a measure showing the name of the country or a measure that calculates the variance between Actuals and Budget for a specific country. The measure we are using is the following:

"<b>" &
MIN(Data[Country]) &
":</b> variance between Actuals and Budget is " &
[Variance Actuals - Budget] The red part of the measure is HTML or hard coded text. With <b> and </b> we define the start and end of the text which should be bold.

MIN(Data[Country]) simply returns the name of the Country [Variance Actuals - Budget] refers to a measure which calculates the difference between Actuals and Budget.

Adding a dimension to the category placeholder

 

Once you have created the measure, all that's left to do is to add the additional dimension to the category placeholder. As you can see in the sample file, we added the Country from the Data table into the category placeholder.

To better understand how this feature works, why don't you go ahead and remove the country from the category placeholder in the sample file?

Once you are familiar with these basics, you can take it to the next level by combining this with some other skills you can learn in the Knowledge Base.

Click here to learn how you can let the user dynamically change the font size

Click here to get introduced to some of the most common HTML tags for formatting (bold, italic, underline, etc.)