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,
I have created MonthYear column and representing on line graph x axis. But the column is showing as vertical values. PFA.
I want to display it horizontally or slighted tilted so that it can be readable.
Solved! Go to Solution.
I was able to do it using below :
Hi @Anonymous,
I would suggest you reduce the size of the labels and enlarge its width. The more useful solution is adding a space between the year and the month. Then it will take two rows automatically.
MonthYear = FORMAT([Datekey], "mmmm yyyy")
Best Regards,
Thanks for your reply.
I dont have a date table. I have a table in which there is a Week Column. So, I have used following dax :-
1) MonthNumber = MONTH('MLITrend'[Week])
2) Month Name = SWITCH('MLITrend'[MonthNumber],1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December")
3) Year = YEAR('MLITrend'[week])
4) MonthAndYear = CONCATENATE('MLITrend'[Month Name], 'MLITrend'[Year])
and this MonthAndYear column is used in line graph. The dax which you have provided is not working on Week column.
I was able to do it using below :
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |