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.
I feel that this is a really simple issue that I just can't seem to resolve. The raw data is in date format but I want to show the information by month. As you can see in the photo, its splitting it up in chronological order without consolidating them into months. Any ideas as to how I respolve this would be much appreciated 🙂
Solved! Go to Solution.
Hi @mbrierley,
If you click on the dropdown for your date value on the axis, you should see a menu with an option to create a "New Group".
Select this and you'll see an option to create "bin size" - you should be able to choose a bin size of "1 month".
Click OK and there should be a new value in your date table called "Date (bins)" (or something similar, depending on what your date is called).
You should use this field and replace the date field in your graph.
Hope that helps,
Alex
Hi @mbrierley,
If you click on the dropdown for your date value on the axis, you should see a menu with an option to create a "New Group".
Select this and you'll see an option to create "bin size" - you should be able to choose a bin size of "1 month".
Click OK and there should be a new value in your date table called "Date (bins)" (or something similar, depending on what your date is called).
You should use this field and replace the date field in your graph.
Hope that helps,
Alex
That's the one! Thanks 🙂
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |