Export the data that was used to create a visualization

[Anonymous]

@Greg_Deckler 

How to give name of the report to the file ,when i am exporting data into xlsx/csv from the visualization.

[Bizualisation · Accepted solution]

Hi

I don't think this is currently possible as the file is always exported as "data". Depending on your usecase you could investigate using a flow / automate to rename the files.

[Anonymous]

@Bizualisation @V-pazhen-msft @Greg_Deckler 

How to change the slicer date format from month/day/year to day/month/year.

Thanks.

[Bizualisation]

This is a bit of a different issue, but no worries

You need to change the format of your date. You can just change the format using the column tools or you can use a DAX statement to make a calculated column like FORMAT( [date] , "dd/mm/yyyy")

Thanks

[Anonymous]

@Bizualisation 

Hi , I tried changing the format of the date field but it still doesn't affect the the format in the slicer.

Thanks

[Bizualisation]

OK, try just deleting the slicer and lets start from scratch!

First check the date you want to use is formatted correctly and then pop it in a new slicer and that should work.

If it still won't play ball you may want to investigate your regional settings as PowerBI does try to default to your locale, especially in the online version. However, in the desktop it should obey the formatting rules you've set. If it doesn't work please post a screenshot of your date column - we will get there, don't worry!

[Anonymous]

Date Table:

Date =

ADDCOLUMNS (

CALENDAR (DATE(2000,1,1), DATE(2025,12,31)),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Year", YEAR ([Date]),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

"MonthNameShort", FORMAT ( [Date], "mmm" ),

"MonthNameLong", FORMAT ( [Date], "mmmm" ),

"DayOfWeekNumber", WEEKDAY ( [Date] ),

"DayOfWeek",FORMAT ( [Date], "dddd" ),

"DayOfWeekShort", FORMAT ( [Date], "ddd" ),

"Quarter", "Q" & FORMAT ( [Date], "Q" ),

"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )

)

[V-pazhen-msft]

@mvarun01

After my research, I'm afraid he couldn't make it in Power BI for now. You can export to Excel and then rename the Excel file.

For your requirement, you could publish your new idea to Power BI Ideas and have this feature come sooner.

Paul Zheng Community Support Team _
If this post helps, please consider Accepting it as the solution to help other members find it more quickly.

[Greg_Deckler]

@Anonymous , I agree with @Bizualisation 

[Bizualisation · Accepted solution]

Hi

I don't think this is currently possible as the file is always exported as "data". Depending on your usecase you could investigate using a flow / automate to rename the files.

[Anonymous]

@Bizualisation @Greg_Deckler @V-pazhen-msft 

While exporting you can change the name from "data" to anything for your visualization/table.

If you give title to that viz and try to export data it will take your title as name for the file on its own.

Thanks 🙂

[Anonymous · Accepted solution]

@Bizualisation @Greg_Deckler  Is there a way to automate the name for the file?