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.
How can i work with this kind of data? Monthly or weekly data.
Power BI wont recognize the months or weeks as date or date/time or anything meaningful.
I tried to look at videos and threads, but i cant seem to find a decent article or video that covers working with weekly or monthly data in Power BI.
Solved! Go to Solution.
Hello,
for Monthly Data you have two possibilities depending if your raw data changes from time to time or not.
Easiest Way would be a calculated column
SWITCH(Table1(Month) 'January' 1, 'February' 2, 'March' 3, 'April' 4, 'May' 5, 'June' 6, 'July' 7, 'August' 8, 'September' 9, 'October' 10, 'November' 11, 'December' 12,)
Then you have to sort your Month by your new caculated month column table.
Alternatively you could built a table with MonthName and MonthNumber and relate Month and MonthName. If you then add MonthName from MonthTable to your chart it should work as well. MonthName has to be sorted by MonthNumber.
For weeks you can add a Calculated Column as well.
RIGHT(Table2[week],Len(Table2[week])-6)
Sort Week by WeekNumber and everything should be fine.
Hello,
for Monthly Data you have two possibilities depending if your raw data changes from time to time or not.
Easiest Way would be a calculated column
SWITCH(Table1(Month) 'January' 1, 'February' 2, 'March' 3, 'April' 4, 'May' 5, 'June' 6, 'July' 7, 'August' 8, 'September' 9, 'October' 10, 'November' 11, 'December' 12,)
Then you have to sort your Month by your new caculated month column table.
Alternatively you could built a table with MonthName and MonthNumber and relate Month and MonthName. If you then add MonthName from MonthTable to your chart it should work as well. MonthName has to be sorted by MonthNumber.
For weeks you can add a Calculated Column as well.
RIGHT(Table2[week],Len(Table2[week])-6)
Sort Week by WeekNumber and everything should be fine.
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 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |