When Power BI reports are created, the focus is mostly on numbers and it's often forgotten that the recipients also need comments/text to actually know why the numbers are the way they are.
With the HTML Text Styler visual, comments can be dynamically created and formated which will make it extremely easy for the end-user to quickly see the most important message of the report.
This can be done with dynamic DAX measures but of course, you can also load existing comments from Microsoft SharePoint, Excel or any other source system.
If you have comments which are saved in HTML, the visual can display them properly but you can also create comments directly in Power BI Desktop.
Using the HTML Text Styler visual will improve the readability of your reports tremendously which will then lead to better business decisions.
The HTML Text Styler can be imported from the Microsoft AppSource. To do this, click on More visuals > From AppSource in the Power BI Desktop menu. After that, search for HTML Text Styler. Click Add to install the visual.
There are countless different formats in HTML. Therefore we cannot provide a complete list. However, we can assure you that the most important and most common formats are possible.
In the Knowledge Base we show you how to work with different formatting options.
Take a look at this demo report to see a few examples: Demo report
There are several ways to convert text to HTML. One option is to use an online tool for this. A search for "word to html" returns a list of online converters.
Another option is the use of Microsoft PowerApps. Contact us and we will show you, how the PowerApp we developed works.
In general, there are 2 ways you can format text.
- If you are using the PRO version of the visual, you can change it in the format settings of the visual. In the screenshot below you can see the format settings which you can change. Of course, on top of this, you can change any kind of format with HTML code.
- You can use HTML to add formatting and this is really what makes this visual so powerful! Take a look at the Knowledge Base to learn how you can do this.
Note that HTML code will gain precedence over the settings you apply to the visual.
Of course! For maximum flexibility, DAX measures can also be used.
To create fully dynamic text which is also dynamically formatted, you can combine DAX with HTML. This might sound difficult but actually it isn't, take a look at the Knowledge Base to learn how to do it.
And if you still have questions after looking at the Knowledge Base, just get in touch with us, we're happy to help you out.
No, that's not necessary. The license key can be stored in the JSON theme. Contact email@example.com and we will create the appropriate JSON file for you.
Yes, absolutely. You can download a sample report from here. Make sure to look at the DAX code in the measures, this is where we added some explanations which show you how this report does its magic.
Absolutely, yes! The HTML Viewer was a popular visual but it was also lacking one important feature. It couldn't handle measures. This is one of the big advantages of the HTML Text Styler over the HTML Viewer so yes, this visual can definitely replace the other one and can do even more.