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,
here is sample data
I have a slicer based on the metric of YYZ and integrated, yyz, and All are linked to YYZ via metric
Having three separate line graphs for each yyz, integrated, and All work perfectly...that is,whenever i change the metric via the slicer, all three graphs update perfectly
what i'm trying to do here is actually have Integrated and 'All' on the SAME line graph...so when I move the "Σ value" from the "All" table to the "secondary y-axis" (i even tried double stacking the "y-axis") of the "INTEGRATED" chart, the "all" line graph is just a straight line.
it looks like it's giving me the TOTAL of the metric spanning the time period , not the individual data points (e.g., let's say time period is from Jan to Mar and the revenue was $1,$2,,$3, respectively. the line graph for the "all" is showing $6 (1+2+3) straight line, not upwarding sloping as in $1, $2, $3)
Solved! Go to Solution.
SOLVED
i had to make a common, separate dates table and made all the other tables refernce this
SOLVED
i had to make a common, separate dates table and made all the other tables refernce this
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |