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.
Hello,
I'm looking for some guidance on displaying a cumulative total of 'x' over month and dayOfmonth, with the lines broken out by year (will have 3 years of data). I was able to quickly resolve this issue in Tibco Spotfire, but I seem to be struggling with it in Bi. Any help would be much appreciated!
Thanks,
Chris
Solved! Go to Solution.
HI @Anonymous ,
You can add a calculated column to extract and stored day of month from date fields, then create a chart with year fields as axis, 'day of month' as legend, amount fields as value with aggregate mode 'sum'.
Regards,
Xiaoxin Sheng
HI @Anonymous ,
You can add a calculated column to extract and stored day of month from date fields, then create a chart with year fields as axis, 'day of month' as legend, amount fields as value with aggregate mode 'sum'.
Regards,
Xiaoxin Sheng
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |