Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I currently have a matrix table that, when selecting a single date, works perfectly. However I am having issues of my matrix duplicating to the right based on the multiple dates selected on the slicer.
For example, if I have 8th March selected, it will show fine. When I select the 8th March and 15th March, the 15th March will append all columns to the right hand side instead of summing the original columns with both dates' data.
Thank you for the help in advance.
@alex9999 This is happening because you took Date in Column field of matrix. If you want the result to be summed one after another so use the Date column in Row category.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |