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.

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

Thanks. Do you mean add it as a visual level filter on the table or the bar chart? When I added it on the table it didn't seem to change anything, but when I added it on the bar chart it removed the 100% completed project, so it's kind of opposite to what I wanted as I wanted it to remove on the table? 

 

Thanks! 

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