Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Time Slicer YTD thru Today

  • 1.  Time Slicer YTD thru Today

    Top Contributor
    Posted Sep 17, 2021 02:13 PM
      |   view attached
    Hello Community:

    I currently have a client that wants to have the report open up always set to todays date. I will attach the visual I am concerned with. Since this matrix draws from a time slicer and a synchronized disconnected time slicer to arrive at the measure results I am not sure how to set the main slicer for this year to 1/1/2021 to 9/17/2021  and tomorrow it would be 1/1/2021 to 9/18/2021 and next Jan 13th it would cover the time from 1/1/2022  to 1/13/2022 and so on.

    As you will see with the attached column image there is an awful lot of time intelligence functions being used and some harder DAX written in to arrive at the results. I reference last year same month, MTD, YTD, MTD + thru EOM, etc. all in this same visual.

    Additionally the client doesn't want to see the slicer. Is this possible? If I just create a slicer for today it seems as though that might work...?

    Here are a few measures being used:

    PY Month Sales = CALCULATE([MTD Sales],PARALLELPERIOD('Dates'[Date],-12,MONTH))

    DS EOM Total Open Orders =
    CALCULATE(
    [Total Open Orders],
    FILTER(
    ALL( Dates ),
    Dates[Date] >= [Harvest Min Date] &&
    Dates[Date] <= [Harvest EOM Date]
    )
    )


    Thanks for any input either way.

    Best regards,

    Bill

    ------------------------------
    William Skelley
    01106
    Longmeadow MA
    8602807221
    ------------------------------

    Attachment(s)



  • 2.  RE: Time Slicer YTD thru Today

    Top Contributor
    Posted 29 days ago
    Hello:

    I have figured it out. I added a relative slicer for This Day and updated the DAX for the measures. So no need to reply.

    Thank you.

    ------------------------------
    William Skelley
    01106
    Longmeadow MA
    8602807221
    ------------------------------