Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |