Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello Everyone,
I have been trying to create a pivot table like shown below, is there any way to do it in Power BI
Solved! Go to Solution.
Hi @tabuzahra ,
Just add the fields of your data to rows of the matrix visual.
I'm assuming that you have a table of Projects and a table of tasks, just adapt to your model.
Check PBIX file attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @tabuzahra ,
Just add the fields of your data to rows of the matrix visual.
I'm assuming that you have a table of Projects and a table of tasks, just adapt to your model.
Check PBIX file attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you so much
| User | Count |
|---|---|
| 43 | |
| 35 | |
| 26 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 65 | |
| 57 | |
| 40 | |
| 21 | |
| 20 |