Matrix columns to only show First and Last Date of Slicer

[guillaume_cyr]

I have a matrix when the columns are based on a table column containing the last day of every month. I also have a slicer based on the same column. When the user selects an interval on the slicer, the matrix columns automatically adjusts to only shows the dates between this interval.

Would it be possible to only show the first and last dates selected in the slicer?

[v-henryk-mstf]

Hi @guillaume_cyr ,

According to the requirements you provided, I looked at the solution provided by @parry2k  and tested it. I think it is a feasible solution.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@guillaume_cyr you probably have to create a measure then use it in a visual level filter

Filter Date = 
VAR __minDate = CALCULATE ( MIN ( Table[Date] ), ALLSELECTED() )
VAR __maxDate = CALCUALTE ( MAX ( Table[Date] ), ALLSELECTED() )
VAR __currentDate = MIN ( Table[Date] )
RETURN
IF ( __currentDate = __minDate || __currentDate = __maxDate, 1, 0 )

and use the above measure as a visual level filter where the value is 1.

If this doesn't work, share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[guillaume_cyr]

It did work. Thanks a lot!

[parry2k]

@guillaume_cyr not fully sure what you are looking for. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[guillaume_cyr]

My post was not loaded correctly. It was missing part of my question.