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.
Having a issue I can't search a solution for. I've tried others, but I just can't make this work.
I have a single Table that contains each time a user logs in. I want to have a yearly cumalitve total on a graph. I can't get them to display over each other - just side-by-side. (when by month)
I started with an ALL Cumulative measure--- this works great and restarts at the YEAR mark.
I have two measures that divide the counts into two years.
Then I have these to get me a cumulative total.
2021
How do I get them to share the same month on the graph (overlap the year)
I'm so close - just missing the mark. Thank you in advance.
Solved! Go to Solution.
UPDATE: This soultion solved this. https://community.powerbi.com/t5/Desktop/Line-Charts-with-Cumulative-values/m-p/169590
UPDATE: This soultion solved this. https://community.powerbi.com/t5/Desktop/Line-Charts-with-Cumulative-values/m-p/169590
Hi @TDisco,
Why don't you try creating a table just a list of month names and number, no year or date column. Join the month number from this new table to the month number in the date table and use month name as X-Axis in your visuals.
Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI
No-go, but thank you
(not sorted - but still, same response)
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |