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.
Hello Community,
I have a problem with Report Builder - I cannot justify the text (to the left and right as I would normally do in MS Word).
I know this issue has been mentioned several times, but maybe someone has a simple solution that can be implemented quickly and easily.
In Report Builder (there is no justify icon).
There is such an option in MS Word.
Thank you very much in advance for your contribution!
Solved! Go to Solution.
H All,
I found a solution that works perfectly and consists of 3 steps:
1. Creating references to System.Drawing.dll and System.Windows.Forms.dll.
2. Uploading the custom code to Report Builder (one piece under the other).
3. Calling the function that was loaded in the previous step.
Details are available here: SQL Server Reporting Services (SSRS): How to Justify Text (Part 2) (phidiax.com)
Final result:
Hint:
H All,
I found a solution that works perfectly and consists of 3 steps:
1. Creating references to System.Drawing.dll and System.Windows.Forms.dll.
2. Uploading the custom code to Report Builder (one piece under the other).
3. Calling the function that was loaded in the previous step.
Details are available here: SQL Server Reporting Services (SSRS): How to Justify Text (Part 2) (phidiax.com)
Final result:
Hint:
Do you know if this can be replicated in Power BI Report Builder?
Power BI Desktop/Power BI Report Builder do not have justify option currently. if you really want this option, I suggest you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas.
If you are willing to use Power BI, here is a workaround (based on this old thread) :
Get more visuals :
Then add the HTML Content visual :
Write out your text in any text editor adding the in-line css `<div style=text-align:justify;line-height:2>` to the outer html tag holding the text e.g. div, span :
Add the text column into the HTML content value shelf
Hi @AmiraBedh,
Thanks for your contribution on this topic.
My goal is to achieve the justification effect in Report Builder, so your solution is not suitable for my situation.