Forum Discussion

User4520's avatar
User4520
New Member
1 year ago

Show certain timeframe upon opening report

I have 12 months worth of data.  It looks very congested on the page when displaying all 12 months.  Can I only show 6 months default upon opening, like a filter preset, with still having the user be able to add/filter the timeframe once opened?  

Need Help

2 Replies

  • POSPOS's avatar
    POSPOS
    Icon for Post Partisan rankPost Partisan
    1 year ago

    User4520  - you can try adding a slicer and restrict to the first six months which will default the report to only 6 months. Additionaly the user can change the time frame from the slicer to any selection.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    1 year ago

    Hello, Good day
    I had the same thing, but I wanted to always show the current week and I did the following, in a calendar table I added this column

    Current Week = IF('General Calendar'[Week] = WEEKNUM(TODAY()) && 'General Calendar'[Year] = YEAR(TODAY()),"Yes","No").
    Then in the model view I left it as the default segmenter, so that
    In the same way, when you deselect it, you can see all the data

    You can do the same perhaps with CURRENT MONTH + 6, or easier, Separate the Year into SEMESTERS 1 and 2

    I hope I have helped you
    Best regards