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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
npanchal
New Member

Excel Formatting

Hello,

 

I am trying to import formated excel data in Power BI but Power BI uanble me to preseve the data formatting from excel. Below are couple of example for formatting i like to preserve in Power BI. Can anyone help me how to achieve this.

 

Thank You!

 

npanchal_1-1638961210674.png

 

npanchal_2-1638961221656.png

 

 

 

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @npanchal ,

 

It's not supported to keep the format when loading data from excel to Power BI.

The first screenshot is similar to Matrix but does it does not support merging cells.

Not very clear about the second screenshot. Do you want to keep the drop-down arrows? What do these drop-down arrows do?

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
TomMartens
Super User
Super User

Hey @npanchal ,

 

unfortunately, you can't import a format from an Excel file, you only import data.

This means you have to recreate the "formatting".

From the samples you provided, I would start with the Matrix visual, next try the inforiver custom visual.

 

If you are backed by Premium licensing, either Premium Per Capacity or Premium Per User you also might try to use Paginated Reports.

 

Hopefully, this provides some new ideas on how to tackle your challenge.

If not, consider creating pbix files using Power BI Desktop that contain sample data, after you have imported data from the Excel file you want to "mimick". Upload the pbix to onedrive or dropbox and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
amitchandak
Super User
Super User

@npanchal , I doubt the above excel format is possible. You can have textbox on top of the matrix.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.