I have a grid of 9 tables on a report page that summarrize 3 different attributes Vs 3 other attributes.
I would like to rotate a textbox 90 degrees to lable the Row of tables.
Seems like a basic function, am I missing something?
Solved! Go to Solution.
This is 2021 now and appears still mission impossible. I am not a big fan of all of those 3rd party visuals as they commonly come with lack of support and robust testing therefore lots of bugs. For example, the text enhancer does not provide any font to choose and I can't even move the object on the canvas but only resizing as workaround.
Another workaround is to make your text in word and use those functions to rotate to how you want it, take a screenshot, and then import it as an image. Definitely laughable that this has to be a solution but this is power bi...
Another solution is to create the vertical text in a cell in Excel. This can be snipped and saved as a .jpg image. The image can then be inserted into the Power BI report.
Yeah @I_Like_Pi , there doesn't seem to be a great solution just yet. The best way I've found is creating an image in either InDesign or Illustrator with transparency grid turned on and the words I want at the angle I want (see below). Of course this requires having some version of Adobe Creative Cloud software (or something like it) AND going back and forth between applications, but it's the best I've found. I've added a super small, quick example below.
My work around is to use the y-axis of a graph to write and format the text vertically. I then take a snippet, save, and insert the image where I want it.
MAQ just released a plugin in the store called "Text Enhancer" that does all kinds of things, including text rotation. No workarounds needed.
I used this and it worked pretty well, the only challenge being that you have to set up your text in a table - which is doable but a bit annoying.
I am using text enhancer. I set the text direction is Vertical L to R. I uploaded my report on power Bi report server, but Internet explorer can't read the vertical direction. Please see the image below:
That workaround is for some static value. Tha will work fine. Mine is a text enhancer whose value is dynamic based on user selection. For example if user selects GDP option from slicer than this vertical textbox will show GDp , if user selects Population then it will show population.
There are many CSS or compatibility issues with IE(Internet Explorer).
Apparently this is STILL not an option??? Come on Microsoft. I'm having to replace an image with text because of a bug where the images don't load when published to the web. Now I can't duplicate the 90-degree text that was in the image with a simple text box? This is getting ridiculous.
I was shocked to see the answers in this thread regarding not being able to rotate the contents of a textbox. This is a BASIC element for Enterprise reporting.
I just figured out a workaround for this item that I am being forced to utilize because I refuse to take no for an answer when needing to distribute a report.
Hopefully this works for anyone reading this post:
This is nothing more than a workaround, and I may have to deploy this using this workaround.
I just did what you described below as I replicated an excel combo chart in power bi, and had to edit the axis title.
Do you realize the text size max out at 21? It did for me. When the text size goes to 22 there is an error indicator for "Y-axis".
Nice one! Its high time Microsoft got this simple feature to a text box. wonder if we have a custom visual which does that yet?
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!