topic Re: PowerBI Preset date selection and custom selection with comparison period in DAX Commands and Tips

PowerBI Preset date selection and custom selection with comparison period

Lauraneville — Thu, 16 May 2024 15:17:13 GMT

Hello,

We are trying to make a preset date list that compares the same time period last year, whilst also having the option to use a custom filter with the ability to also use a custom comparison date.

For some context we have set up the preset date list and have added a dax calcualtion to show the same time period for the previous year i.e. it will show 01/05/2024 compared to 01/05/2023. However, we can not then get a custom date selection with the option to use an additional calendar for a comparison.

We've found loads of videos showing how to do this for a single date, but not including a comparison date. Any help would be hugely appreciated!

Thanks in Advance!

DataContet

Re: PowerBI Preset date selection and custom selection with comparison period

lbendlin — Fri, 17 May 2024 15:44:50 GMT

You can use Field Parameters, or you can use the standard "Latest Value as Default" pattern

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

Make sure not to confuse your report users. Keep it simple.

Re: PowerBI Preset date selection and custom selection with comparison period

Anonymous — Fri, 31 May 2024 06:35:02 GMT

Hi Lauraneville ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,

Clara Gong

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