Forum Discussion

julsr's avatar
julsr
Icon for Continued Contributor rankContinued Contributor
7 months ago
Solved

Create Buttons for Drill Down

Hi everyone!   I have a line chart with a date hierarchy, and I would like to use buttons instead of the default drill-down lines/arrows to go to the next level. Is this possible? Here is an exampl...
Need Help
Show and Tell
Tips and Tricks
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    1) Create one visual per level

    Create four visuals, all using the same measure:

    Visual

    X-Axis

    Chart – Year

    Year

    Chart – Quarter

    Year > Quarter

    Chart – Month

    Year > Month

    Chart – Week

    Year > Week

    Use the SAME size and position for all charts and stack them exactly on top of each other.

     

    2) Hide all visuals except ONE

    Open Selection Pane:

    • Hide:
      • Quarter chart
      • Month chart
      • Week chart
    • Leave Year chart visible

     

    3) Create bookmarks 

    Create 4 bookmarks:

    Bookmark Name

    Visible Chart

    BM_Year

    Year chart

    BM_Quarter

    Quarter chart

    BM_Month

    Month chart

    BM_Year

    Week chart

     

    For every bookmark:

    • Data → OFF
    • Current page → OFF
    • All visuals → OFF
    • Selected visuals → ON

     

    4) Configure each bookmark properly

    Example: BM_Month

    • Show Month chart
    • Hide Year / Quarter / Week charts
    • Update bookmark

    Repeat for all.

     

    5) Create navigation buttons 

    Insert → Buttons → Blank

    Create buttons:

    • Year
    • Quarter
    • Month
    • Week

    Button action:

    • Type: Bookmark
    • Bookmark: corresponding BM