Forum Discussion
Helper IIHow can i restrict a text based filter by date
Hi,
I have a Project Type field which contains the following attributes:
CTB - A
CTB - B
RtB - A
RtB - B
this is a filter at the top of the report - using a slicer.
How can i restrict what is shown in this filter based on the date selected from the date picker (slicer) also sitting at the top of the report. The date is taken from the Date table which is connected to the main projects fact table.
So if the user picks any date before 2022 -they should only see CTB - A and CTB - B in the project type filter, and when they pick a date in 2022, they can see all 4 project types.
How can this be achieved?
Any help would be appreciated.
Thanks in advance.
1 Reply
- Greg_Deckler
Community Champion
Malsk1_1 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
