How to track multiple categories number increase or decrease for today vs. monthly average

Adrian122 — Thu, 15 Feb 2024 17:52:09 GMT

Hi everyone,

Sorry for being the noobest noob in Power BI.
I find the app to be so exciting and cool, however I started working on it just a week ago in order to track trends at work.
I am in deep trouble now :))

I want to track a bigger array of categories on a daily basis compared to a monthly average.
I work in customer service and I have to track trends preferrably by percentage, for categories of cases.
So I would like to have as the basis value of comparison the average day value calculated for the last month for example. I can pull out a report and do a pivot in excel for this and just have 2 columns 1. category name 2. category value
This one I would need to be calculated as a daily average to compare the daily stats of the categories vs. how many of these categories have entered daily on average.

A	B	C	D
Categories last month	Values of category last month	Categories today	Values of categories today
Accessories features	3	Account issue	3
Accessories prices	1	Delivery issue	5
Account issue	60	Issue with getting gift/voucher/product for free	8
Account set up/change process	31	Order fulfilment	3
Age verification issue	56	Others	1
Bluetooth related	1	Positive (product related)	1
Broken device	5	Sticks features	1
Burnt Taste	1	Where to buy accessories	1
Cancel the order	14
Chargeability Battery	52
Components of the starter kit	3
Corporate Enquiry	1
Data access request (DSR)	1
Deleting consumer account	1
Delivery issue	245
Delivery query	10
Device alarm indication	3
Device constant reboot	12
Device features	26
Device not working	35
Device Prices	1
Device replacement due to consumer fault	3
Device stop working	53
Device vibration	5
Difference with Competitors	1
Durability Battery	7
Excessive heat in charger (heat injury)	1
Excessive heat in device (heat injury)	11
Excessive heat in vapor (heat injury)	6
Front panel	6
Functionality Cover	17
How to charge	1
How to find the referral code	9
How to place an order	9
How to register device	10
How to use device	7
Ingredients/Components	5
Issue with getting gift/voucher/product for free	204
Issue with placing the order	33
Issue with product availibility/OOS claim	5
Issues with accrual of points	2
Issues with device registration	15
Job request	3
LED indication	79
Mechanics and conditions	101
Miscellaneous Accessories	1
Miscellaneous Device	39
Miscellaneous Sticks	43
New Supplier Proposal	5
Order fulfilment	69
Order issue/incorrect item	22
Other (provide comments)	18
Other Service issue	1
Others	186
Portfolio expansion	4
Positive (other)	11
Positive (product related)	26
Product launch date	28
Product Specification/Producer	1
Refund issue	3
Removing from 3rd party database	128
Replacement delivery issue	2
Request for return	29
Request for Trial	3
Return & Refund conditions	18
Service issue	3
Service Proposal	34
Site crashed	3
Spam	8
Sticks features	22
Sticks Prices	3
Store locator issue	1
Taste	4
Tobacco stick stuck in the device	28
Tobacco stick uneven heat distribution	4
Vapor generation	6
Visual appearance	1
Warranty & replacement conditions	10
Where to buy accessories	8
Where to buy device	17
Where to buy sticks	41

Stats would kind of look like this.

So if the category from column C is found in column A, then I would like to see see a percentage increase/decrease of its value (D) vs. the average of the values from the last month (values fro column b ivided by 31.

Many many many thanks in advance!

Re: How to track multiple categories number increase or decrease for today vs. monthly average

lbendlin — Tue, 20 Feb 2024 00:25:23 GMT

Please indicate the expected outcome based on the sample data you provided.

Re: How to track multiple categories number increase or decrease for today vs. monthly average

MQaiserJaved — Fri, 31 May 2024 10:26:54 GMT

Hi @Adrian122

From the use case you described. I make the following (Comparison Bar Chart) custom visual in Power BI. I hope it will fulfill your requirement.

Data Format:

You can find this custom visual Comparison Bar Chart by ChartExpo here.

Thanks & Regards,

topic How to track multiple categories number increase or decrease for today vs. monthly average in Custom Visuals Development Discussion

How to track multiple categories number increase or decrease for today vs. monthly average

Re: How to track multiple categories number increase or decrease for today vs. monthly average

Re: How to track multiple categories number increase or decrease for today vs. monthly average