Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I've been researching and looking for ways to do this transform with no luck. Being new to PowerBi and PowerQuery any help/hints will be greatly appreciated.
The percent next to the blank Year/Month field is the average of the percents from the six month time span. It is not needed. (if that helps)
Is the following possible within PowerQuery?
Outside data source report output on the left.
What I need to create dashboard reports on right.
Thanks!
Solved! Go to Solution.
Do the following:
1) Right click on the Departments colum , click Fill=>Down
2) Filter out blanks from Year/Month
I would actually stop here and keep the 3 column layout - with it you can achieve the view you want using the Matrix visual, plus it's much easier to manage with time hierarchy etc (you can actually do joins with a Calendar table, use time intelligence etc.) Still, if you really need that layout in PQ then
3) Pivot column Year/Month in the Transform ribbon
Do the following:
1) Right click on the Departments colum , click Fill=>Down
2) Filter out blanks from Year/Month
I would actually stop here and keep the 3 column layout - with it you can achieve the view you want using the Matrix visual, plus it's much easier to manage with time hierarchy etc (you can actually do joins with a Calendar table, use time intelligence etc.) Still, if you really need that layout in PQ then
3) Pivot column Year/Month in the Transform ribbon
Works great! It makes so much sense now. I was getting hung up on the Fill Down and blanks to null.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |