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.
Hi Guys,
Struggle a bit with this,
Read various posts but none that handle the exact issue:
I need in a clustered column chart to show sales per week (x-axis)
One measure that shows Actuals
One Measure that shows compare period
Two slicers being able to set date filters on both actual period and compare period
Should be able to show both values if the time period selected in both slicers is within the same time period or completly different.
Example:
Slicer Actual date: 1-1-2020 to 1-2-2020
Slicer Compare date: 1-1-2020 to 15-1-2020
Or:
Slicer Actual date: 1-1-2020 to 1-2-2020
Slicer Compare date: 2-2-2020 to 28-2-2020
I have offcause a date table but as well tried with a Compare date table and UseRelationship function.
Any suggestions?
Data example
Sales Date | Sales |
1-1-2020 | 300 |
20-1-2020 | 700 |
5-2-2020 | 500 |
27-2-2020 | 900 |
25-2-2020 | 300 |
10-1-2020 | 400 |
8-1-2020 | 200 |
Solved! Go to Solution.
@Anonymous , You need an independent date table for that
How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg
or
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
@Anonymous , You need an independent date table for that
How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg
or
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
With some tweeking your first link helped me achive my desired result - Thanks a lot! 🙂
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
32 | |
30 | |
18 | |
18 |