Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I am new to Power BI. Pls guide me with the problem below:
I have survey data which is coming every day. I am using likert scale (1, 2, 3, 4, 5) and wanted to do cumulative sum or frequency count for each likert category (1, 2, 3, 4, 5) with respect to date e.g: if I drill down to month it should give me cumulative sum of each category of the data in that specific month along with its total no. of data set in that month when I use waterfall chart. My sample data set is given below.
I made second table to find the sum of each category by using group by specifiying Overall learning experience column and applying count rows operation. This provided me new table with the total count of each category but not by month, date. When I drill down to month the sum of each category are mixed and end total responses exeeds. Total no of responses are 479.
Please see the pictures
Correct
Total sum of each category per month is ruined as well total no. of responses also get wrong as correct value is 479
Total sum of each category per day is ruined as well total no. of responses also get wrong as correct value is 479
Please guide me how to solve this issue. I wanted to see total no of responces of each category along with its independent total overall, by month, day, so on. Also I want to make separate chart for only 1 and 2 rating by using DAX or what ever!!!
Regards.
|
Solved! Go to Solution.
Hi @HassanMoosa ,
Thank you for your sharing! But I am not sure which column you will used to calculate value and you said that you "made second table to find the sum of each category", I can't view this table in your sample. I use another simple sample to calculate cumulative value, you could refer to it for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HassanMoosa ,
Thank you for your sharing! But I am not sure which column you will used to calculate value and you said that you "made second table to find the sum of each category", I can't view this table in your sample. I use another simple sample to calculate cumulative value, you could refer to it for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dax thanks for helping me out. I will look into your soultion and will get back to you soon.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
28 | |
23 | |
12 | |
11 | |
10 |