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

Thank you! This has helped. It's not filtered my table completely but it has removed the 100% completed tasks and then adding percentages in my project category table has helped with being able to drill through onto the 100% completed tasks anyway, so it's solved my issue, thanks. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi taralouise123 ,

 

Thanks for your feedback.

 

Best regards,

Adamk Kong