Forum Discussion
Turn Off Banded Rows in Data Exported to Excel from Power BI
Hello,
The following screen shows the results of exporting data from a Power BI Table visualization to Excel. I'm wondering if there's a way to not have the exported data be displayed in Excel with banded rows (every other row is highlighted with a color). I need this in an Excel file and not as a csv file. I also dont want to export to csv and then save as Excel..
I haven't found any options to turn banded rows off in Power BI and I haven't been able to remove the banding in Excel using either cell formatting or conditional formatting. Thank you for any suggestions you can offer.
Hi,
Click on any cell of the Table and click on Table Design in the Ribbon. In Table Styles, select the first one without formatting.
4 Replies
Hi,
Click on any cell of the Table and click on Table Design in the Ribbon. In Table Styles, select the first one without formatting.
You are welcome.
Hi Anonymous,
Did Ashish_Mathur's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestion to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng