Forum Discussion
Laagen
3 years agoRegular Visitor
Create a shift time filter
Hi! Can someone help me, I´m trying to make a filter with 7 selections to only get data from the timespan with the right label. i got Night1 23:00-03:00 Night2 00:00-03:00 Night3 03:00-06:00 mor...
- 3 years ago
To create a filter with 7 selections for the timespan labels you provided, you can follow these steps:
- Go to the data source you want to filter and select the column that contains the timespan labels.
- Click on the filter icon or right-click on the column and select "Filter".
- In the filter dialog box, select "Text Filters" or "Number Filters" depending on the type of data you have.
- Choose "Contains" or "Equals" as the filter condition, depending on your needs.
- Enter the label you want to filter on, for example, "Night1", "Morning1", etc.
- Click on "OK" to apply the filter.
Repeat these steps for each label you want to filter on. This will allow you to get data only from the timespan with the right label.
If you want to adjust the filter selections, you can go back to the filter dialog box and modify the filter conditions or remove the ones you no longer need.
Laagen
3 years agoRegular Visitor
Thanks!
I dont know what im doing wrong but i cant find 'Table (3)'[TimeField] it only shows other Dax-Calculations, Any ide what im doing wrong?
DOLEARY85
Resident Rockstar
3 years agoTable 3 is your table and time field is your field within the table that contains the time.
If you're not seeing any of your data source fields check you are creating a calculated column and not a measure.