How to Rotate Text Box in Power BI
Trying to rotate a text box in Power BI can feel like a surprisingly difficult task. You click on the text box, look for the little rotation handle you're used to from other design tools, and find...nothing. Don't worry, you aren't missing something obvious. This article will show you the simple workaround to create perfectly rotated text, plus another clever trick for more advanced dynamic text labels.
Why Rotate Text in a Dashboard?
Before jumping into the "how," it’s helpful to understand the "why." You’re not just rotating text for fun, it solves real dashboard design problems. Properly used, rotated text can significantly improve the clarity and efficiency of your reports.
- Saves Valuable Canvas Space: Dashboards are prime real estate. Vertical text allows you to label charts, sections, or slicer panels without eating up precious horizontal space.
- Clearly Labels Vertical Charts: This is the most common use case. When you have a vertical bar or column chart, long horizontal axis labels can either get cut off or force the chart to shrink. Rotating the labels by 90 degrees lets them fit neatly.
- Creates Visual Groupings: A vertical text label running alongside a group of related visuals (like a set of KPIs or slicers) acts as a clean, space-efficient header that visually ties them together.
- Adds a Polished Design Element: Sometimes, it’s about aesthetics. Used sparingly, rotated text can break the monotony of horizontal layouts and guide the user's eye, contributing to a more professional and custom feel.
The Secret: Don't Use a "Text Box"
Here’s the core of the problem: Power BI's standard "Text box" object from the Insert menu lacks a rotation property. You can resize it, change its color, and add text, but you can't spin it.
The solution is wonderfully simple: use a Shape instead. Shapes have the same text capabilities as a Text Box, but they also come with a rotation setting. By using a shape, adding your text to it, and then making the shape itself invisible, you get the floating, rotated text you're looking for.
Step-by-Step Guide to Rotating Text Using a Shape
Follow these steps to create your rotated text. Let’s say we want to create a vertical label that says "Marketing Campaign KPIs."
1. Insert a Shape
First, skip the "Text box" button. Instead, navigate to the Insert tab in the Power BI Desktop ribbon. Click on Shapes and select the Rectangle (or any other basic shape).
2. Add Your Text to the Shape
With your new rectangle shape selected, look to the Format pane on the right-hand side of the screen. Under Shape settings, find the Text section and expand it.
- Toggle the Text switch to On.
- A text input box will appear. Type "Marketing Campaign KPIs" into the box.
- Adjust the font, font size, color, and alignment as needed. For a vertical label, you'll probably want to center the text both horizontally and vertically.
3. Make the Shape "Invisible"
Right now, you have rotated text inside a visible box, which isn't what we want. The next step is to make the shape's background and border disappear.
Still in the Format pane for the shape:
- Expand the Fill section and change the Color to be 100% transparent or simply toggle it Off.
- Expand the Border section and toggle it Off.
Your shape now looks exactly like a standard text box with a transparent background.
4. Rotate It!
This is the final step. In the Format pane, switch from the "Shape" settings to the "General" settings tab (the little wrench icon).
- Expand the Properties section.
- Find the Rotation setting.
- You can either type in an exact degree or use the slider. For bottom-to-top vertical text reading upwards, enter 270 degrees. For top-to-bottom vertical text reading downwards, enter 90 degrees.
That's it! You now have a perfectly rotated text element that you can drag and place anywhere on your report canvas.
Advanced Method: The Single-Category Bar Chart Hack
The shape method is perfect for static text. But what if you need to display rotated text that comes from a measure or a column in your data model? For example, labeling a chart with a dynamic date range. In this case, you can use a clever workaround involving a single-category bar chart.
The idea is to create a chart, strip away all its elements (title, x-axis, the bar itself), and leave only the y-axis label, which we can control with our data.
When to Use This Method:
- When your text needs to be dynamic (e.g., MAX('Calendar'[Date])).
- When you want the label to change based on a slicer selection.
Step-by-Step Guide for Dynamic Rotated Text
Let's say we want to create a dynamic label showing the name of the currently selected sales region from a slicer.
1. Create Your Data Measure or Column
First, you need the text you want to display in the form of a DAX measure. This measure will capture the selected value from a slicer.
Selected Region Label = "Sales for " & SELECTEDVALUE('Sales'[Region], "All Regions")This DAX measure creates a string that will read "Sales for [Your Region]" when a single region is selected, and "Sales for All Regions" otherwise.
2. Add a Stacked Bar Chart Visual
Add a Stacked bar chart visual to your canvas. Don’t worry, we won’t be using the bar - just its axis.
3. Configure the Chart Fields
- Drag the Selected Region Label measure onto the Y-axis field well.
- You MUST put a value on the X-axis for the Y-axis to display. You can create another simple measure like
Dummy Value = 1and place it on the X-axis.
You should now see a single bar with your dynamic text appearing as the y-axis label.
4. Strip the Chart Down
Now, let's make the chart elements invisible. Select the visual and go to the Format your visual pane:
- Y-axis: Keep this On, but expand it and style the Values (your text) to your desired font, color, and size. Turn the Title off.
- X-axis: Turn it completely Off.
- Gridlines: Turn them Off.
- Data labels: Turn them Off.
- General tab -> Title: Turn the main chart title Off.
- Bars: Go back to the Visual section, expand Bars, and set the color to transparent or the same color as your dashboard background.
After this cleanup, all you should be left with is your horizontal text label. But our goal was rotated text! The stacked bar chart axis labels are a bit stubborn, but we've now isolated the text.
5. An Easier Take: Use the Data Label
For more control, especially rotation, using the data label of the bar is easier than the axis.
- Use a regular Bar Chart.
- Put your
Dummy Value = 1on the X-axis. - In the Format Visual pane, turn On data labels.
- In the data label settings under Values, click the fx button for "Custom label".
- Choose your Selected Region Label measure.
- Find the Rotation option and set it to your desired angle (e.g., 90 degrees).
- Proceed to make the bar color transparent and hide the axis titles and values for a clean, rotated text look.
This method has a few more steps, but it's an incredibly powerful way to incorporate dynamic, rotated text into an engaging Power BI report.
Final Thoughts
Getting your text to display vertically in Power BI isn't direct, but it's entirely possible once you know where to look. By using shapes instead of text boxes for static labels or employing the bar chart trick for dynamic ones, you gain the control needed to build cleaner, more professional, and space-efficient dashboards for your audience.
While mastering workarounds in tools like Power BI is a valuable skill, it also shows how much time can be spent on formatting rather than analysis. We built Graphed because we believe getting insights shouldn't be a battle with your software's interface. Instead of searching menus for a rotation property, you simply connect your data sources and ask questions in plain English like, "show me marketing campaign KPIs by spend" and watch the dashboard build itself in seconds. This lets you focus entirely on what your data is telling you, not the manual steps to make it look right.
Related Articles
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.