Forum Discussion

alir22456's avatar
alir22456
Helper I
2 years ago

Export Visual to CSV

Hi,

I have created a Table viusalization in my Power BI report. The table consists of a list of names of customers. I did export the visualization to csv, but the measure name was also exported along with the values. Is there a way to export only the values and not the column headers / measure names as below:

 

Name1,Name2,Name3,Name4...........

Thanks

Need Help

6 Replies

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi alir22456 ,

     

    You cannot configure the csv output to not get the names, since it's a csv format the first row is always the name of the columns you have in this case the measures names.

    • alir22456's avatar
      alir22456
      Helper I
      2 years ago

      Hi MFelix 

      Thank you for your comment. Can you please tell me how can I modify the below formula to get a list of customer names each in a separate row rather than seperated by comma.

       

      Cohort = 
      VAR __tmpTable1 =
      GENERATE(
      DISTINCT('Table'[Customers]),
      EXCEPT(
      DISTINCT('Table'[Services]),
      CALCULATETABLE(DISTINCT('Table'[Services]))
      )
      )
      VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
      VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
      VAR __Result = CONCATENATEX(__tmpTable3, [Customers], ",", [Customers])
      RETURN
      __Result

       

      Note: I need the names in a new row not a line break

       

      Thanks

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi alir22456 ,

         

        Try the following code:

        Cohort = 
VAR __tmpTable1 =
GENERATE(
DISTINCT('Table'[Customers]),
EXCEPT(
DISTINCT('Table'[Services]),
CALCULATETABLE(DISTINCT('Table'[Services]))
)
)
VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
VAR __Result = CONCATENATEX(__tmpTable3, [Customers], UNICHAR(10), [Customers])
RETURN
__Result

        Unichar(10) is the line break character.

  • sroy_16's avatar
    sroy_16
    Resolver II
    2 years ago

    Hi alir22456 

    Please try using this modofoed DAX and see if it works.

    Cohort =
    VAR __tmpTable1 =
    GENERATE(
    DISTINCT('Table'[Customers]),
    EXCEPT(
    DISTINCT('Table'[Services]),
    CALCULATETABLE(DISTINCT('Table'[Services]))
    )
    )
    VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
    VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
    RETURN
    __tmpTable3

     

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

    • alir22456's avatar
      alir22456
      Helper I
      2 years ago

      Hi sroy_16 

      Encountering the following error:

      a table of multiple values was supplied where a single value was expected.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi alir22456 ,

     

    Whether the advice given by MFelix has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

     

    Best Regards,

    Neeko Tang

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