Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a table of dates and timeslots built entirely in Power Query:
The timeslots are currently 30m long just to make it easier to visulaise - eventually these will be 1 minute if feasible.
I also pull in a .csv file with the following structure:
The .csv file represents periods when a certain condition was true (the PERIOD and MONTH column are superfluous).
There will be one row per period and there can be multiple periods on any given date.
The aim is to produce somelthing like a Gannt-chart as per this post - https://community.fabric.microsoft.com/t5/Desktop/Calculate-subtotal-rows-by-column/m-p/3268562#M109... but that still has multiple row per day if there were multiple periods on that date.
Alternatively, if there is some way to simply build a timeslot table with 0 and 1 directly from my .csv file, that would be good.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.