No video :(

Power BI From and To Date Filtering with One Slicer

Подписаться 47 тыс.

Просмотров 57 тыс.

50% 1

It happens that you might have two fields as From and To date (or Start and End date) in your dataset, and you want a date slicer in the report. The date slicer has to filter records in a way that the FROM and the TO dates are in the range of dates selected in the slicer. There are multiple ways of doing this. In this article and video, I’ll explain a simple but effective method for that.
Study more in my article here:
radacad.com/power-bi-from-and...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad.com/events/
Free books and tools for Power BI: radacad.com
Power BI Helper: powerbihelper.org/
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@rob876 5 дней назад

This is almost exactly what I wanted but it's easy enough to change the DAX to give me what I want. Thank You.

@RADACAD 3 дня назад

Glad it helped

@majidgolnar7415 Год назад

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.

@lubomirjagersky7327 2 года назад

It is nice and easy solution, thank you for your content.

@sardarwaliwardak3972 2 года назад

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

@kennethstephani692 2 года назад

Great video!

@Bharath_PBI 2 года назад

Thank you 👍

@keshavabkanasavi6904 Год назад

This is awesome!!! You have made it in very simple steps. 🙂

@RADACAD Год назад

Thank you! Cheers!

@shoeb1359 2 года назад

Thanks a lot Super like 👏👏👏👏

@gentiperja6801 2 года назад

Smart.. Thank you :)

@brunoottonivaz5121 Месяц назад

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?

@MoeBig50 7 месяцев назад

You are the best thank you

@edhifa 2 года назад

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?

@ignacionavaspascual982 Год назад

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

@wiiori4618 2 года назад

Does this capability only work with select visuals like a table or matrix? Can this work with all other chart types?

@AMBuuren 6 месяцев назад

Darius Ž showed me this, he is a very good man

@DominicKibuga Год назад

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.

@kewal229 2 года назад

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

@JC-hx7dp 8 месяцев назад

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!

@neoandprissy 2 года назад

Is it possible to set a default to and from date range?

@janakmali8243 8 месяцев назад

How to calculate the total number of distinct employees for the given date range? Please provide some information. Thanks

@regiruby1874 2 года назад

I have a jiradump table ,. Where i calculate running total of closed issues sprint by sprint as burnup chart.

@businessexcellence6617 2 года назад

Thanks. I am using the API method, but the dataset still follow the UTC time zone for Today() expression. Please help. Regards.

@Kotraslokesh 2 года назад

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.

@ittohere 3 месяца назад

you are fucking genius you helped me a lot thanksssssssssss

@amardeepwaghmare1315 2 года назад

This solution doesn't work if we remove date columns from visual 😐

@Raito065 4 месяца назад

same with me , did you know how to fix it now?

@quesee08 Год назад

It seems it wont allow you to mark table as date with timestamp in case you need the filter with timestamp..

@RADACAD Год назад

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.