Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a clustered column chart which looks like below. As you can see the format shows as year-month. I do NOT want to unconcatenate the x-axis but instead want to have the format as month-year. Can't for the life of me figure this out. Is there an easy way to do this or do i need to create a date table in order to accomplish this?
Solved! Go to Solution.
if you have a datetime table then create a column
month-year = FORMAT('Table (2)'[date],"mmm")&year('Table (2)'[date])
if you don't have a datetime table, then create this column in the fact table
Proud to be a Super User!
thanks!!
if you have a datetime table then create a column
month-year = FORMAT('Table (2)'[date],"mmm")&year('Table (2)'[date])
if you don't have a datetime table, then create this column in the fact table
Proud to be a Super User!
Actually, there's another problem. The sort now takes place by alphabetical instead of by time. How do I solve this issue?
Ok, I'm being picky, but when I tried to put a space in after 'mmm' to 'mmm ' it went to this. I also just tried to put a space in,
I didn't find the settings for that. I think that depends on the size of your visual
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |