Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Get Activities by comparing between two or more projects in Power BI

Hi,  Here I am trying to compare two projects by creating a slicer visual where one is "BASELINE" and the other is "CURRENT", so when I select a project_id from "BASELINE" and another project_...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you Albert, It is working fine, but when I am trying to compare multiple projects I am getting all the projects that are present in the table but I only want to get the selected project activities. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Meaure Exist_in_Baseline and Exist_in_Current are the same as in the previous example, with the addition of a meaure for determining whether or not the filtering conditions are met

IsBaseline or IsCurrent = 
IF(
    SELECTEDVALUE(Task[proj_id]) = SELECTEDVALUE(BASELINE[proj_id]) || SELECTEDVALUE(Task[proj_id]) = SELECTEDVALUE('CURRENT'[proj_id]),
    1,
    0
)

Apply the measure to the filter on this visual and set it "is 1"

Final output

Best regards,

Albert He

 

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

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    One more thing is like for example from the below image "C321" and "R214" are present in both the projects so the Exist_in_baseline and Exist_in_current should be "Yes" in both the cases.