Apply only start date from an slicer to a matrix

[EstherBR]

Hi, I have a matrix with a date slicer:

I would like that when the user filters the slicer, the matrix ignores the End date of the slicer. In other words the matrix only has tobe filtered by en start date. The slicer settings cannot be changed. 

Thank you so much!

[wc123]

Hello, What is causing you to not be able to edit the slicer settings. You will need to go into the slicer settings and select what the image below shows. you can then adjust the slicer size to hide the end date portion of the filter.

[EstherBR]

Hi @wc123 , The issue is that I cannot change the slicer settings.

[v-saisrao-msft]

Hi @EstherBR,

Could you please confirm whether the issue has been resolved? If not, kindly share the sample data or PBIX file so that we can assist you further in resolving it.

Thank you.

[v-saisrao-msft]

Hi @EstherBR,

Please provide sample Pbix that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample pbix you provided.

Need help uploading data? 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Thank you.

[EstherBR]

Hi @v-saisrao-msft , the issue is not solved. How can I attach a PBIX file to my reply? Thanks

[v-saisrao-msft]

Hi @EstherBR,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[EstherBR]

Hi @mh2587 , still not working 😞

[v-saisrao-msft]

Hi @EstherBR,

Thank you @mh2587, for yor insights.

I've reproduced the issue using sample data and got the same output on my side. I’ve attached the PBIX file for your reference so you can review the setup and results.

Total Sales (Only Start Date) = 
VAR _StartDate =
    CALCULATE (
        MIN ( 'Date'[Date] ),
        ALLSELECTED ( 'Date' )
    )
RETURN
CALCULATE (
    [TotalSales],
    KEEPFILTERS ( 'Date'[Date] >= _StartDate )
)

Thank you.

[EstherBR]

Hi @v-saisrao-msft , Unfortunately, it still does not work as it filters by the start and end date and I only wnat to filter by the start date.

[EstherBR]

Hi @mh2587 , the slicer settings cannot be changed. Thanks

[mh2587]

Create a measure like below and put it in matrix's value

Total Sales (Only Start Date) = //Adjust with your table name and measure
VAR _StartDate =
    CALCULATE (
        MIN ( 'Date'[Date] ),
        ALLSELECTED ( 'Date' )
    )
RETURN
CALCULATE (
    [Total Sales],
    FILTER (
        ALL ( 'Date' ),
        'Date'[Date] >= _StartDate
    )
)

[EstherBR]

Hi @mh2587 , The slicer filters correctly the table, but now the sum of sales is not filtered by year and month. Thanks!

[mh2587]

Replace all() with allselected() like below try this

Total Sales (Only Start Date) = //Adjust with your table name and measure
VAR _StartDate =
    CALCULATE (
        MIN ( 'Date'[Date] ),
        ALLSELECTED ( 'Date' )
    )
RETURN
CALCULATE (
    [Total Sales],
    FILTER (
        ALLSELECTED ( 'Date' ),
        'Date'[Date] >= _StartDate
    )
)

[EstherBR]

Thanks @mh2587 , Unfortunately the new measure does not work either 😞 . 

[mh2587]

Replace the return part with following 

CALCULATE (
    [Total Sales],
    FILTER (
        KEEPFILTERS ( ALL ( 'Date'[Date] ) ),
        'Date'[Date] >= _StartDate
    )
)

[mh2587]

You can disable this in Format section in slicer setting