Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
dlogan
Helper I
Helper I

Formatting Chart Objects

Day 2 of learning Power BI: I am recreating something from Excel and would like to have objects look the same. The image below shows a side by side with Excel on the left. I can't find anywhere that lets me format objects in Power BI similar to the way that can be done in Excel. 

  • Vertical Text Box - Can this be centered veritically?
  • Charts
    • Can I remove "Count of Status" and "Divison"?
    • Instead of the label showing Percent, can it show Count?

I am falling in love with Power BI. Any help would be greatly appreciated.

 

Thanks, Dale

 

dlogan_0-1678805430588.png

 

1 ACCEPTED SOLUTION
AndrewPF
Helper V
Helper V

Carriage return is a new line character. 

Just press "Enter" before the start of your text to move the visible text downwards as many times as you need to get it into the centre of the box. 

View solution in original post

4 REPLIES 4
AndrewPF
Helper V
Helper V

Carriage return is a new line character. 

Just press "Enter" before the start of your text to move the visible text downwards as many times as you need to get it into the centre of the box. 

Now I see. "Carriage Return". Didn't think about it until now. I am guessing that term goes back to the type writer days. 🙂

 

AndrewPF
Helper V
Helper V

Just add carriage returns to the text and it will move it down to the centre of the box. 

You can remove the "Count of Status" and "Division" by switching the X-axis and Y-axis titles to "Off", e.g.: 

AndrewPF_0-1678808393970.png

 

Thanks for your help. I found everything except carriage returns for a text box. Where might I find that setting?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.