Hello,
I am trying to create a Pivot chart with slicers for time and for state! However I am not able to group all of the individual states into one states group to insert the slicer!
Is there anyway to group all into one slicer??
Hello,
I am trying to create a Pivot chart with slicers for time and for state! However I am not able to group all of the individual states into one states group to insert the slicer!
Is there anyway to group all into one slicer??
You need to normalise your data. Each row should contain one fact, and it's associated dimensions. So your source data table should look like:
Time State Value 01:00:00 SC 2 01:00:00 ND 2 01:00:00 CA 2 01:00:00 IN 2 01:00:00 TN 2 02:00:00 SC 4 02:00:00 ND 4 02:00:00 CA 6 02:00:00 IN 5 02:00:00 TN 4
etc
Then you can use it as a source for a pivot table, with slicers on Time and State.
Last edited by Olly; 08-03-2017 at 10:39 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks