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.
Dear All,
I have prepared a matrix visualization with hirarchy where total values are reporting perfectly fine,. but here for one of the column total values need to report how the values is getting on each quarter split as shown in below image:
Example: Current year projected input value is $300, need to split Quarterly as shown. Q1 $100 Q2 $100 Q3 $0 Q4 $100
please suggest and support to acheive this.
Hi @Rajendra1ong ,
May I ask if your problem has been resolved? If @ray_aramburo 's response was helpful, you may consider marking it as resolved. If the issue has not been resolved, please provide detailed data (excluding private information) and your desired output so that we can better understand and resolve the issue you are experiencing.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Just add your Quarter field from your calendar table under the Columns field in your matrix. Just be aware that the Quarter columns will appear in the whole matrix and not only under the "Current Year" section.
Proud to be a Super User!
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 |
---|---|
96 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |