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.
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.
Did not get it completely. But you should unpivot it
https://radacad.com/pivot-and-unpivot-with-power-bi
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
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 |
---|---|
114 | |
99 | |
81 | |
70 | |
61 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |