topic Re: Data Filtering with Dynamic Date Filter in DAX Commands and Tips

Data Filtering with Dynamic Date Filter

Anonymous — Thu, 24 Mar 2022 16:18:47 GMT

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

Re: Data Filtering with Dynamic Date Filter

HotChilli — Thu, 24 Mar 2022 16:32:58 GMT

"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.

Re: Data Filtering with Dynamic Date Filter

Anonymous — Thu, 24 Mar 2022 16:41:37 GMT

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"

Re: Data Filtering with Dynamic Date Filter

HotChilli — Thu, 24 Mar 2022 17:27:55 GMT

"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?