Forum Discussion
Blue2k
4 years agoRegular Visitor
Mobile Data Usage
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...
Dhacd
4 years agoResolver III
Please share a sample data set.
Blue2k
4 years agoRegular Visitor
| 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.
- Dhacd4 years agoResolver III
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:
- Use the measure in the conditional formatting section of the table and select field formatting instead of gradient formatting.
- Make sure the month column's data type is the date and data usage is in the whole numbers.
- Use any color you want in the if condition(Hex codes will also work).
- Update the limit variable as you desire
- Also, note that if there are no values for a user in the last month the last data usage available for that user will be selected here. In this case, there are data for the month of March so April will be compared with Feb, Let me know if you need to change this logic and considered the march data as 0 and calculate the colors.
If you found this works as a solution for you please mark it as a solution.
Thanks and Regards,
Atma.