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
two values in the second row in the cells next to null (markered with black) should be next to the values in the corresponding upper cells
Please advise how i can fix that on Power Query
Need to look at some sample data to work out the steps for you. Please upload the file without confidential/sensitive data to a cloud storage service such as Onedrive/Google Drive/Dropbox/Box (Onedrive preferred) and share the link here.
This would depend on how the data is imported, and possibly what the raw format is. You could try to save it as an Excel file and import that?
that is from a web service called Ditat, I can only download pdf format document, then connecting to that PDF through Power BI
the highlighted part must be on the same row, but it is split into down below of actual row
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |