Forum Discussion

Tze's avatar
Tze
Regular Visitor
8 years ago
Solved

Track usage frequency

Hi there,   I would like to track the frequency of usage via PowerBI. I have a dump file that has the date of which users created a certain configuration every week. e.g. Country -- Product -- Us...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi Tze,

     

    In your scenario, you can simply change Default Summarization to Don't summarize for "Week no" column under Modeling tab, then you should be able to show the frequency of the product being created weekly on the report. :smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi Tze,

 

In your scenario, you can simply change Default Summarization to Don't summarize for "Week no" column under Modeling tab, then you should be able to show the frequency of the product being created weekly on the report. :smileyhappy:

 

 

Regards

  • Tze's avatar
    Tze
    Regular Visitor
    8 years ago

    On my screen, the pull down menu is greyed. 

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft Employee
      8 years ago

      Hi Tze,

       

      What's your data source(Excel files or SQL DB, or others)?

       

      In addition, you need to firstly select the WeekNo column in FIELDS List to be able to change Default Summarization to Don't summarize for "Week no" column under Modeling tab. :smileyhappy:

       

      Regards

      • Tze's avatar
        Tze
        Regular Visitor
        8 years ago

        Thanks, I got it now. :smileyhappy: