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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.