Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 -- User --- Week no. which the product was created
Australia -- E1 -- Steve --- 39
China -- P1 -- Tracy -- 22
etc.
In Excel, I can use the above data to create pivot table showing weekly tracking of which user created which product.
Moving to PowerBI, how can I make it to count the frequency of the product being created weekly? It takes the week no. as numeric and sums them in PowerBI.
Thank you.
BR, Tze
Solved! Go to Solution.
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.
Regards
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.
Regards
On my screen, the pull down menu is greyed.
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.
Regards
Thanks, I got it now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |