Forum Discussion
Unable to slice this table by name:
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. W...
- In the query editor, select all name columns and go to transform tab, and then select unpivot selected columns. This will give you a table with three columns: date, attribute and bake, where attribute column contains the name and the value column contains the number of hours worked for that person on that date.
Now your sliver should work properly 🙂
Please mark this as the solution if this answered your question. Kudos are welcome:)
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.