I had created a MTD and same period last year analysis, and the visual was showing me the data for the last year over to date. This video helped me to filter the visual to date. Thank you so much.
Thank you very much for the nice video. It is very easy to understands. How can we apply the filter on page or all pages instead of individual visual? Thanks
Include this filter as a logical case in your dax measures, then apply the measure in your charts. Then it will work, otherwise explicit filtering through filter pane won’t work.
This video is great. However it only allows for filtering on table visuals. I tried to use the same date filter for a bar graph visual and it dindt work. Is there a way to do something similar for graphs?
Thank you for this. Is there a way to tweak this so that the table would include dates that fall within the specified period? e.g. I have some rows with Start date 17/12/2023 and End Date 20/12/2023. If I apply the filter to select the date range 18/12/2023 to 19/12/2023 the above rows are not being included when I would expect to see them. Is there a workaround for this? Thank you!
Hi @RADACAD. Thnak you for the video. The problem is that this does not work if you make a visual, for example. I guess that we need complex DAX to create a table variable and then insert it into a visual. Can you give any guidelines? Thank you
Hi Reza, thanks for the video. Strangely for me, the formula does not work as expected. I tinkered a bit with the column to see what values the _rangeStart and _rangeEnd return. I discovered that in my case, instead of the slicer's start and end date, the formula was returning the date table's start and end date.
Thanks for this helpful video. I have a query.. I have 6 different date columns. I wanted to make a single Slicer which covers all dates. [It is done by calendarauto()]. And want to make one more slicer which choose which columns date should appear in the 1st date slicer
Hello, thank you for sharing this tutorial. I have a question, I followed the steps to create the slicer, but I got error message on my measure 'InDateRange' : "an invalid numeric representation of a date value was encountered" I checked all my data type for the fields are Date with format DD/MM/YYYY. Any idea what is wrong?
Hi , I have two tables one is job details have fiscal year 2020 ,2021, 2022and another one is transaction details fiscal year 2019,2020,2021,2022,2023 . So i want use slicer in slicer both tables fiscal years have to show . Can you please assist me.
If by timestamp you mean adding time in te filter, then please check my other video about how to work with DATE and TIME dimensions, they best to be seperate columns connected to seperate tables.
I could not figure this out for the life of me, and you explained it perfectly. Thank you for posting this!
Glad it helped!
I had created a MTD and same period last year analysis, and the visual was showing me the data for the last year over to date. This video helped me to filter the visual to date. Thank you so much.
This is almost exactly what I wanted but it's easy enough to change the DAX to give me what I want. Thank You.
Glad it helped
Thank you very much for the nice video. It is very easy to understands. How can we apply the filter on page or all pages instead of individual visual? Thanks
Amazing! It really helps! Thanks!
Glad to hear it.
Darius Ž showed me this, he is a very good man
Life saver! Many thanks for this tip 🙏
You're welcome!
This is awesome!!! You have made it in very simple steps. 🙂
Thank you! Cheers!
Does this capability only work with select visuals like a table or matrix? Can this work with all other chart types?
Include this filter as a logical case in your dax measures, then apply the measure in your charts. Then it will work, otherwise explicit filtering through filter pane won’t work.
This video is great. However it only allows for filtering on table visuals. I tried to use the same date filter for a bar graph visual and it dindt work. Is there a way to do something similar for graphs?
How to calculate the total number of distinct employees for the given date range?
Please provide some information.
Thanks
Thank you for this. Is there a way to tweak this so that the table would include dates that fall within the specified period? e.g. I have some rows with Start date 17/12/2023 and End Date 20/12/2023. If I apply the filter to select the date range 18/12/2023 to 19/12/2023 the above rows are not being included when I would expect to see them. Is there a workaround for this?
Thank you!
You are the best thank you
Hi @RADACAD. Thnak you for the video. The problem is that this does not work if you make a visual, for example. I guess that we need complex DAX to create a table variable and then insert it into a visual. Can you give any guidelines? Thank you
It is nice and easy solution, thank you for your content.
Hi Reza, thanks for the video. Strangely for me, the formula does not work as expected. I tinkered a bit with the column to see what values the _rangeStart and _rangeEnd return. I discovered that in my case, instead of the slicer's start and end date, the formula was returning the date table's start and end date.
This doesn't seem to work for Matrix tables.
This solution doesn't work if we remove date columns from visual 😐
same with me , did you know how to fix it now?
Is it possible to set a default to and from date range?
Great video!
Thanks for this helpful video.
I have a query.. I have 6 different date columns.
I wanted to make a single Slicer which covers all dates. [It is done by calendarauto()].
And want to make one more slicer which choose which columns date should appear in the 1st date slicer
Thank you 👍
Hello, thank you for sharing this tutorial.
I have a question, I followed the steps to create the slicer, but I got error message on my measure 'InDateRange' : "an invalid numeric representation of a date value was encountered"
I checked all my data type for the fields are Date with format DD/MM/YYYY. Any idea what is wrong?
Thanks a lot
Super like 👏👏👏👏
I have a jiradump table ,. Where i calculate running total of closed issues sprint by sprint as burnup chart.
Thanks. I am using the API method, but the dataset still follow the UTC time zone for Today() expression. Please help. Regards.
Hi , I have two tables one is job details have fiscal year 2020 ,2021, 2022and another one is transaction details fiscal year 2019,2020,2021,2022,2023 . So i want use slicer in slicer both tables fiscal years have to show . Can you please assist me.
It seems it wont allow you to mark table as date with timestamp in case you need the filter with timestamp..
If by timestamp you mean adding time in te filter, then please check my other video about how to work with DATE and TIME dimensions, they best to be seperate columns connected to seperate tables.
Smart.. Thank you :)
سلام ، استاد هیچ راه حلی داره که خود اسلایسر حدودش با انتخاب از ویژوال تغییر کند ؟!
you are fucking genius you helped me a lot thanksssssssssss