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,
My current bar graph shows Jan Feb Mar of 2018....then after Dec 2018 shows Jan Feb Mar...etc for 2019. That's nice, but what I really need is to show Jan 2018 next to Jan 2019, Feb 2018 Feb 2019, etc...
Any help is appreciated!
Solved! Go to Solution.
There are a few ways to do it.
1. You create a column month number in your time dimension table and make it as the sort column.
2. Create column month and year separately and use year a legend in the bar chart
month No = format(date,"MM") Month Name = format(date,"MMM") Year = format(date,"YYYY")
Hi @Anonymous ,
You can sort the visual using Months field, so all "Jan" will com together.
If you click the ellipsis icon on your visual you can see the option to sort.
Regards
Aswin
No, that is not what I am looking for and does not work. What that does is aggregate the months together - meaning it just shows the combined total of Jan 18 and Jan 19 in one bar, Feb 18 Feb 19 in the next bar etc.
I need Jan 2018, let's say, in an orange color, then Jan 2019 right next to it, in a blue color (for example)
There are a few ways to do it.
1. You create a column month number in your time dimension table and make it as the sort column.
2. Create column month and year separately and use year a legend in the bar chart
month No = format(date,"MM") Month Name = format(date,"MMM") Year = format(date,"YYYY")
Thank you Amitchandak! It was so obvious it was staring right at me! I did not even think about using the Legend.
Appreciate it!!!
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |