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 Hello,
I have category and date. i need to create month wise sales like
:- Jan,Feb,March month then Qtr 1
:- Apr, May,June Then Qtr 2
For full Year
Please find the attachement required ouput sample for reference.
Solved! Go to Solution.
@Anonymous , if you have a calendar table with month, quarter, you can put them and matrix column and this should be possible.
quarter and then the month. So that quarter become subtotal
For Matrix
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Hi @Anonymous ,
You could set this in Matrix like below
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.
@Anonymous , if you have a calendar table with month, quarter, you can put them and matrix column and this should be possible.
quarter and then the month. So that quarter become subtotal
For Matrix
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Using the Matrix table you should be able to do this just fine. Ensure your date is set as a hierarchy,
then use the drill-down function to bring it down to Q, M, and years.
Hi Karlos, Thank you for your inputs and nearly matched my expected output.
Small thing is that i want remove the total of row end.
in your sceenshot 462, i need remove that total for all rows.
Appreciate for your help..!!
Hi @Anonymous ,
You could set this in Matrix like below
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 @Anonymous ,
Can you share some sample data for this?
Also, if you have got a date hierarchy column, you can use it on a matrix to achieve what you are looking for.
But having some visibility on your data will help in answering.
Thanks,
Pragati
@Anonymous
Can you share your source data as table or Excel, it will be helpful to create the solution faster
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |