Forum Discussion

taralouise123's avatar
taralouise123
Icon for Helper I rankHelper I
2 years ago
Solved

Filter rows of a table based on another visual

Hi,    I want to show of projects/milestones and percentage completion, but only show rows where percentage completion is not 100%- BUT when I click on another visual e.g. a bar chart, it will filt...
General Comment
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi taralouise123 ,

     

    You can try formula like below to create measure:

     

    M1 = IF(MAX(Projects[Percentage Completion]) = 1,1,0)
    M2 = IF(MAX(Projects[Percentage Completion]) = 1,0,1)
    result = IF(ISFILTERED(Projects[Project Name]),[M1],[M2])

     

     

    put result to table filter, if not select column in visual, the table visual shows not 100% rows:

    after select column about 100%, the result show below:

     

    Best Regards,
    Adamk Kong

     

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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

taralouise123 , Add it on table Drag the ShowTasks measure to the visual-level filters pane.
Set the filter to show only where ShowTasks is 1.

taralouise123's avatar
taralouise123
Icon for Helper I rankHelper I
2 years ago

Ah yeah- I've added it on but doesn't seem to be working! 

 

 Measure is:

 

ShowTasks =
   IF(
       ISFILTERED('ROCC Project Planner'[Project Name]) || ISFILTERED('ROCC Project Planner'[Milestone Fix]),
       1,
       IF(
           MAX('ROCC Project Planner'[Percentage completion]) < 1,
           1,
           0
       )
   )
 
and filters on the visual are: 
 

 

Thanks