Forum Discussion
ghdunn
Helper III
6 years agoStacked Bar Waterfall - problems with Measures and Calculated Columns
I would like to create a Stacked Bar Waterfall. I can spoof a simple version in this way: Month Name Hard Coded Count 1 Jan Bob 1 1 Jan Fred 1 1 Jan Mary 1 4 Feb Bob 1 4 ...
sturlaws
Resident Rockstar
6 years agogood point that the chart should work when filtering for type. But, to do so I would need to add yet another stand-alone table, with even more code, and I am not sure it would even work. What you can do instead, is to have three versions of your table. 1 with both types, as you have now, and 2 tables containing only Permanent and Temp, respectively. Duplicate the measure in each table, and create 3 identical charts. Then instead of a slicer, create buttons and bookmarks to switch between them.
ghdunn
Helper III
6 years agoSturla,
Thank you for your outstanding effort on this - way beyond the call of duty. It will take me a little while to work through your solution and see what I can learn and I will let you know where I get.
Thanks once again!
Gerald