Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Automatically rename a data export file (csv or excel)

Hello, Is it possible to set the export csv or excel file name automatically for users so that they do not need to name the file when they extract data? Either the filename and/or a workbook name wi...
Need Help
  • avatorl's avatar
    avatorl
    6 years ago

    It works like I descirbed. Just make sure a visual has title. Table/matrix visuals by deafult have title disabled. Add a title.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry, yes I mean export a visual, such as a matrix or table. So you're saying it will export and name it the visual's title if there is one, correct?

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

It is a good habit to add a title to each visual, maybe you can create a dynamic title, like this.

Measure 3 = 
IF(
    ISFILTERED(Sales[Brand]),
    "Sales of  " &SELECTEDVALUE(Sales[Brand]),
    "AAAA"
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Has your problem been solved?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yes, thank you all! I have marked the solution appropriately. 

  • NikNithiy's avatar
    NikNithiy
    Helper I
    2 years ago

    v-lionel-msft  Is it possible to get the same thing in exported excel sheet (as a sheet name)