Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
It did work. Thanks a lot!
@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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
My post was not loaded correctly. It was missing part of my question.