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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!