Forum Discussion

tellme's avatar
tellme
New Member
7 years ago

Generate trends with multiple CSV files

Hi I have many CSV files with the same number of columns and names. Each CSV is a vulnerability assessment report. Each file has 13 columns showing item like this:   Vulnerability       Hos...
Need Help
Show and Tell
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi tellme ,

From your description, how could you want to add the year, I could find no relationship with your data and your year, could you please offer more information and post your desired result if possible?

 

Regards,

Daniel He

  • tellme's avatar
    tellme
    New Member
    7 years ago

    Hi v-danhe-msft 

     

    Thank you for replying.

     

    Yes, my CSV files do not have any Year data but each file entries have the same date/Year. My qestions are:

     

    1. Is it possible to associate the file with a date manually during creation of a chart? If not, is the only way to add year column and the year value in the CSV file before exporting? For any file its Year is all the same for all its entries.

     

    2. In each file there are hundreds of vulnerabilties and hosts. First I want to combine all the files in Power BI and then create charts similar to the one shown below. How to do this?

    image location: https://ibb.co/0MQJ9pb

     

    Thanks