Forum Discussion

domi25's avatar
domi25
Frequent Visitor
1 year ago
Solved

Filtering the data

I have a 'Projects' table in my report with a 'project start date' column. I have two tables 'Period' and 'Month+year' they are connected to the 'project start date'. In the report, I would like to h...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for dharmendars007 's reply ,please allow me to provide another insight.
    Hi domi25 ,

    Please try the following steps.

    Create two slicer table.

     

    Slicer1 = SUMMARIZE(Project,Project[Start Date])

Slicer2 = SUMMARIZE(Project,Project[Start Date])

     


    Put the Start Date field of both Slicer tables into both slicers.

    Slicer1 is used to select a date range and the slicer2 is used to select a specific date.

     

    Then create a measure.

     

    Measure = 
IF(SELECTEDVALUE(Project[Start Date]) IN VALUES(Slicer1[Start Date]) || SELECTEDVALUE(Project[Start Date]) IN VALUES(Slicer2[Start Date]),1,0)

     

     

    Then place this measure in the visual containing the data as well as in the filter, setting the condition to is 1

     

    Then you can see past and future projects.

     

     

     

     

     

     

     

     

     

    Please see the attached pbix for reference.

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

domi25's avatar
domi25
Frequent Visitor
1 year ago

The solution you presented works exactly like mine. What I meant was an answer to the question of whether the kind of filtering I want is possible. I want to be able to select (in your solution) 'FUTURE' in one slicer and 'January 2023' in another, and I want to see all those projects. However, with this solution, they are mutually exclusive, and records not appear because January 2023 is not in the future. What I want is to see all future projects and that one from the past."

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for dharmendars007 's reply ,please allow me to provide another insight.
Hi domi25 ,

Please try the following steps.

Create two slicer table.

 

Slicer1 = SUMMARIZE(Project,Project[Start Date])

Slicer2 = SUMMARIZE(Project,Project[Start Date])

 


Put the Start Date field of both Slicer tables into both slicers.

Slicer1 is used to select a date range and the slicer2 is used to select a specific date.

 

Then create a measure.

 

Measure = 
IF(SELECTEDVALUE(Project[Start Date]) IN VALUES(Slicer1[Start Date]) || SELECTEDVALUE(Project[Start Date]) IN VALUES(Slicer2[Start Date]),1,0)

 

 

Then place this measure in the visual containing the data as well as in the filter, setting the condition to is 1

 

Then you can see past and future projects.

 

 

 

 

 

 

 

 

 

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.