Forum Discussion
Formatting Calendar
I have a data set, which includes a column for year (2019 and 2020) and a column for Month and a calendar week (1,2,3...)
What I would like to do is for my charts and cards visuals to show daily data feeds. Is it possible to format the columns so that they are recognized as year and calendar week ? Or is there a visual I can use to show daily data ?
Thanks.
2 Replies
You should be able to reverse engineer a date using a variation of something like Week Starting: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123
Did not get it completely. But you should unpivot it
