Forum Discussion
Data Filtering with Dynamic Date Filter
Hi!
I was wondering if there was any way we could filter the data to only show the members with a status of 1. For example, only show members who have not left.
I attached a sample power bi file down below. The challenge I am having is with the date filter being seperated into 3 seperate widgets (one for year, day and month).
Thank you in advance!
https://drive.google.com/file/d/1oR4QG84p9dLltpGeJBRTGM3SsstNhUv5/view?usp=sharing
3 Replies
"filter the data to only show the members with a status of 1" - you can do this in the filter pane. Assign a value to Status from there.
--
Separate issue : The date slicers are going to make things complicated for you. Maybe think about simplifying your model.
When I try to do it in the filter pane, the status is not filtering for the just the data the dax command to make it only filter the data before and including the selected date.
Also, I know the date filters make it more complicated but I have to include an option to have the automatically set to "Today"
"When I try to do it in the filter pane, the status is not filtering for the just the data the dax command to make it only filter the data before and including the selected date." Sorry, I do not understanding this.
Filtering the visual using status = 1 will only perform that action. What is it that you want to do?
