Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
First post in to the powerbi forum so firstly Hello,
id like to in powerbi with info from sharepoint build an excel type spreadsheet that more or less looks like this
Ive more or less figured out the basics of powerbi, however i cannot find any info on how to do this
Id like for the date to be shown on the x-axis and to move the values around using the slider, ive got several start and finish hour columns in sharepoint with a calculated total column using the following formula ***=CONCATENATE(INT(Downtimedes1fin3-Downtimedes1start3)," Days ",TEXT(Downtimedes1fin3-Downtimedes1start3,"h"" hrs ""m"" mins """))*** as my tasks go over 24hr time and with a choice column for the task type.
Id also like for this info to be show in minutes?
Is my sharepoint configured correctly for this (i can change it) and how would i go about doing this?
Hi @Anonymous
Is the data format of this screenshot in sharepoint excel table or Is it what you expect to get via Power BI?
You'd better to provide original data in data source and expected result format in power bi, so i can make a test to find the solution.
Best Regards
Maggie
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!