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 experts,
I am new to PowerBI. am trying to use the timeline as an x-axis in stacked area chart, and count how many projects are being done every minute. How should I set up the timeline down to minutes within a certain period of time (e.g.: from January 1st to the end of January)?
THANKS a lot.
Best,
Chen
Solved! Go to Solution.
Hi @ChenChristyYu,
You can create a calendar table using Power Query (New Source -> Blank Query). Then, create a relationship between this calendar table and your source table based on date/time field.
let Source = Table.FromColumns({{Number.From(#date(2018,1,1))..Number.From(#date(2018,1,31))}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Times(#time(0, 0, 0), 48, #duration(0, 0, 30, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom") in #"Expanded Custom"
Best regards,
Yuliana Gu
Hi @ChenChristyYu,
You can create a calendar table using Power Query (New Source -> Blank Query). Then, create a relationship between this calendar table and your source table based on date/time field.
let Source = Table.FromColumns({{Number.From(#date(2018,1,1))..Number.From(#date(2018,1,31))}}), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}), #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Times(#time(0, 0, 0), 48, #duration(0, 0, 30, 0))), #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom") in #"Expanded Custom"
Best regards,
Yuliana Gu
Hi Gu,
Thanks for your reply. I am curious if I want to create a new table based on other queries in the same PowerBI project, what is the code format for the source? for example, I want to create a new table called 'returns' selecting columns from table 'sales', how can I do it.
Sources = ...?
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 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |