Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Add custom column to Usage Metrics

I am using the Usage Metrics dataset for my workspace.  I want to enrich the dataset with a day of week column or measure.  I am looking for usage trends by day (ie. Monday vs Friday etc.).   I can...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

I'm afraid the usage metric is automatically generated by power bi service based on the dataset. You can create an extra report/visual to reach your requirement.

 

Community Support Team _ Jimmy Tao

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
    7 years ago

    v-yuta-msft  Jimmy, thanks for your reply.  Yes, I am working within the restriction that the dataset is generated by the Power BI service.  I have connected to the dataset and created my own custom report - I need guidance on how to create a custom column and/or measure to enrich the data set and allow me to report by the day of the week.

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Anonymous ,

       

      Could you share more details about your specific requirement and post some sample data?

       

      Regards,

      Jimmy Tao

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        v-yuta-msft Jimmy, I would like to add a custom column or measure to the Power BI generated usage metrics dataset so that I can monitor usage by day of the week - Sunday, Monday, Tuesday etc.. How do I create this additional data with the date values available.  No sample data - all data is generated in the Power BI generated dataset.

         

        Regards