Forum Discussion
Show data between 2 Date Filters
I want to show the data where the column "Termini" it's between "Termini Inicial" (Start Date) and "Termini Final" (Final Date).The 2 Date Filters
Hi Shadowestien ,
Delete the relationship between the tables, and then try the following formula to put the value of measure into the filter on this visual to show the result as 1.
If the problem is still not resolved, please point it out or provide test pbix file. 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.
15 Replies
Hi Shadowestien ,
Try a formula similar to the following, select the date values in each of the two slicers and filter out the corresponding values that meet the specified date.
M = VAR a = SELECTEDVALUE ( slicer[Start] ) VAR b = SELECTEDVALUE ( slicer[End] ) RETURN CALCULATE ( MAX ( 'Table_'[Value] ), FILTER ( ALL ( Table_ ), MAX ( 'Table'[Date] ) <= b && MAX ( 'Table_'[Value] ) >= a ) )
If the problem is still not resolved, are you able to provide some test data (remove sensitive information) to facilitate me to answer for you as soon as possible. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi, thank you so much for your answer it seems it can be what I need.
But I don't have full Knowledge about PowerBI, could you explain me how can I do this.
I mean I don't know what are the "reference name" of the filters, and this function where do I have to apply it?Thanks again btw.
Hi Shadowestien ,
Is your question confused about how to create formulas? Then type in the formula you want to try and save it. Put it into the corresponding table visual to display the corresponding results.
If there is still confusion, you can provide a sample pbix file and I will answer it for you as soon as possible.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I'm having the same initial problem. My objective is show the data between two selected dates (start date and end date), both selected by different filters.
However, I could not implement this measure correctly. Could you share the .pbix file with this example?
Sorry for the English, I'm Brazilian. Thanks.
Shadowestien , Not very clear, But these should help
How to divide/distribute values between start date or end date or count days across months/days: https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
This example doesn't help me because I need it for visual filtering, that the user can change it every moment.
hello , do you find a solution?
If you want to filter a visual between 2 periods.
For the sake of example let say from 2020 to 2021 only.
Go to filter pane, insert date column on either specific visual or entire page to limit it between these 2 days.
I'm sorry if I didn't understand ur answer, but I don't know what are u telling me to do, because this filter is active on the entire page.
But how the two filters are the same column I can't apply a filtering in "Start Date" and a different one for the "Last Date"
