Forum Discussion

eugenm's avatar
eugenm
Icon for Helper II rankHelper II
5 years ago
Solved

Synchronize 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 (sep...
  • jdbuchanan71's avatar
    5 years ago

    eugenm 

    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]
        )
    

     

  • parry2k's avatar
    5 years ago

    eugenm yes you can, you can use ISINSCOPE function.