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.
I have a table that shows how many hours each worker worked on each day. Dates in the first column. Name of worker at top of the following columns with the hours they worked below their name.
When I use this table in Power BI I am able to drag the dates column to a slicer to slice the data by date. But I'm not able to drag more than one name column so that I can divide the data by name. It seems like an intuitive way to slice the data. But I'm unsure what I'm doing wrong. Any suggestions for how I could slice this data by name?
Reorganizing the table is not a problem.
Solved! Go to Solution.
Proud to be a Super User!
@Anonymous ,
In query editor, click all the name columns-> click the unpivot. Then you will achieve two columns [Attribute] and [Value]. Drag the [Attribute] column to the slicer.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be a Super User!
This solution worked. Can't believe I forgot that. Thank you very much for your help.
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 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |