Forum Discussion
Helper IISynchronize chart hierarchy level selector with separate slicer
Hi folks,
Can someone please advise how I can synchronize the chart hierarchy selection with a separate slicer?
At this point I have a selector that controls a different aspect of the chart (separate code for the values calculation) and the output must be in sync with the hierachy level. Without this functionality a user has to make appropriate selections in both the chart visual heireachy and in the selector. This is a clumsy ux, to say the least.
I trust that this can be done, but I could not find any proper reference to it anywhere.
I would prefer that my slicer controls the visual hierarcy in the chart, but I would be OK with the visual passing the selected visual level, which then I can use it as a slicer value for my code snippets.
Thank you in advance,
Eugen
Is your Size slicer populated from a small table with just 'Daily', 'Weekly', 'Monthly' in it? If so you might be able to make a bands table that would look something like this.
Size Band Daily 0-15 Daily 15-30 Daily 30-45 Daily 45-60 Daily 60-75 Weekly 0-50 Weekly 50-100 Weekly 100-150 Weekly 150-200 Weekly 200-250 Monthly 0-500 Monthly 500-1000 Monthly 1000-1500 Monthly 1500-2000 Monthly 2000-2500 Then you put the Band from this table in your chart and link it into your model. You could also just use the band from the table above in your slicer and switch your calc based on the selection made, something like this.
Display Amount = VAR _Size = SELECTEDVALUE ( 'Bands'[Size] ) RETURN SWITCH ( _Size, "Daily", [Daily Measure], "Weekly", [Weekly Measure], "Monthly", [Montly Measure] )
