Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |