Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all!
I am trying to use Power Bi to analyze mobile data month to month.
I was wondering if there is a way to see the changes each month for users. Seeing ones that have significant changes.
Also I am trying to see the top 30 users each month and determining terminated accounts.
Many thanks!
I am still not able to flag the ones that are significantly different from the others.
Still have not figured out a way to see an outlier for data usage?
Please share a sample data set.
Username | Data usage (GBs) | Month |
csherborn0 | 36 | Jan |
llorenzetti1 | 84 | Jan |
thuddlestone2 | 86 | Jan |
tleseka | 56 | Jan |
csherborn0 | 80 | Feb |
llorenzetti1 | 72 | Feb |
thuddlestone2 | 63 | Feb |
tleseka | 69 | Feb |
csherborn0 | 92 | Apr |
llorenzetti1 | 83 | Apr |
thuddlestone2 | 74 | Apr |
tleseka | 66 | Apr |
Here is an example of my data set. I want to be able to see trends if that is possible on Power Bi.
Seeing significant changes from month to month.
Based on my understanding I have created a calculated column that I think works for this case,
What this measure will be doing is highlighting the cells which have an increase in data consumption greater that a particular value that we can set inside the calculated column.
The measure and the working screenshot are attached below.
Conditonal Formatting =
Var lim = 10
Var usage = sum('Table'[Data usage (GBs)])-CALCULATE(sum('Table'[Data usage (GBs)]),filter('Table',earlier('Table'[Month])< max('Table'[Month])))
return if(usage>lim,"Red","Green")
Few things to note:
If you found this works as a solution for you please mark it as a solution.
Thanks and Regards,
Atma.
Update: Read wherever I have mentioned "measure" as "calculated column".
So I am confused on why those are read.
i am trying to see significant changes from month to month.
I believe you want to find out the difference in usage between the current month and the previous month. In that case, use the below code as a calculated column, It might be working for you.
If this post helps, then please consider accepting it as the solution to help the other members find it more quickly.
Thanks and regards,
Atma.
When I try to make the new column and put in what is above. It gives me a token Eof expected after the 10.
I got it to work. But I do not get how the red green works because it just selects certain ones.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |