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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors