Hi there,
I've built a stacked area graph based on demand for different food types. Each category is defined at three levels: Level 1 (Vegetarian/Non-veretarian), Level 2 (fruit, vegetable...), and Level 3 (apple, bannana....).
I'd like the user to be able to view this data at each of the three levels, depending on thier preference.
I've tried setting up the "Level" as part of a hierarchy, but when I try to drill up/down I only manage to interrogate the date hierarchy. I'd be equally satisfied if the "Level" could be defined by a slicer. I thought I'd found a way to do this by using a DAX expression to dynamically filter the column in the legend field, but so far nothing I've done has worked.
Below is an example showing what I'm trying to model. Clockwise from top right shows that three "levels" I want the user to be able to select - I'd just like it to be available in one visual. Sample screen grabs of my data tables also below.
1 ACCEPTED SOLUTION
Create a field parameter which includes the three levels and use that on the slicer and in the legend.
Field parameters!
Sir, you've just saved my bacon! That is exactly the functionality I was looking for. Thank you for your response and letting me get on with the rest of my day! 🙂
Create a field parameter which includes the three levels and use that on the slicer and in the legend.
