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 , Create a measure for filter first

ShowTasks =
   IF(
       ISFILTERED('Table'[Project Name]) || ISFILTERED('Table'[Next Major Milestone]),
       1,
       IF(
           MAX('Table'[Percentage Completion]) < 1,
           1,
           0
       )
   )
 

Select the visual where you want to show the projects/milestones and percentage completion.
Drag the ShowTasks measure to the visual-level filters pane.
Set the filter to show only rows where ShowTasks is 1.
Create Your Visuals:

Create the visual that shows the projects/milestones and percentage completion.
Create the bar chart or any other visual that you will use to filter the data.
Test the Interaction:

Click on the bar chart or any other visual to apply the filter.
The table visual should now show the 100% completed tasks when a filter is applied.
When no filter is applied, the table visual should exclude the 100% completed tasks.

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