Forum Discussion
Helper IIIFacebook Power BI report (Video Attached)
Does the community have experience with extracting demographic info from facebook?
I'm trying to extract and visualize our fb demographic information.
But all the breakdowns expand on columns and not as rows.
When I transpose the data, I lose all the column header information
Hi FrugalEconomist,
In your scenario, you need to treat header row as first data row of table, then transpose rows and columns. Please follow steps below:
1. Check "Use Headers as First Row" option.
2. Click Transpose button.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
2 Replies
- ImkeF
Community Champion
Is it always only one row returned? Then this would be easiest:
Demote headers first, then transpose.
v-qiuyu-msftCommunity Support
Hi FrugalEconomist,
In your scenario, you need to treat header row as first data row of table, then transpose rows and columns. Please follow steps below:
1. Check "Use Headers as First Row" option.
2. Click Transpose button.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
