Forum Discussion
Solved
Dynamic table columns based on slicer selection
I am creating a power bi report that is filtered by Month, Year, Employee, Certification. The first column of the table is Day (of the month) that shows even days that do not have data, so I have ev...
Hi CMSGuy - two primary options: either use a field parameter as your column value, or just unpivot your data. The approach depends on the other details of your reporting. Can be a table or a matrix, doesn't matter.
Now I need to research field parameters as that is something I have not explored using yet. When I do an unpivot, there are actually more than a few columns and are just not the Tasks titles. There is TaskHours and TaskSubmitted numbers too. Not sure how to use that pivoted data when there is more than one different value type