![]() I vote we just keep guessing our way through this problem. I admit that I created this by hand, but … I bet the Unpivot button in Power Query would rock this out pretty well! ![]() The resulting table is at right and, I don’t find it crazy or surprising, really. My theory is to use a standard “unpivot” technique. So, we are going to make a brand new table. And we know that we need all the values on our axis in a single column. It would be sinchy (US children slang for “easy” ) to have a graph of total sales by brand or category, but we want to have a single graph that lets a slicer choose flavor we want. Over to the right you see a sample of what the ProductMaster might look like. So, instead of showing Sales across Years, I can flip and show Sales across Quarters with just a slicer click. Or maybe… flip through … because if two levels is interesting, clearing *3* levels is even more interesting! Over to the left you see the relevant part of a model – with a Sales (fact) table and a ProductMaster (lookup table). The goal is to have charts where the axis/labels/columns/whatever can change via a slicer. Okay, I got distracted and was wondering how long I was sitting on this… and it looks like this thread over on the Mr Excel forums came back to life about a month ago and got me thinking about it… I have been sitting on this post for awhile (that looks weird in one word – should that be “a while”? Let’s just skip that discussion).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |