Forum Discussion

PC2022's avatar
PC2022
Helper III
1 year ago
Solved

Matrix/Table

I have comments associated with each project in my datasource which are displayed at the bottom of the visual. In my matrix visual i have a list of PMs/Projects on the left side and even if a project...
Need Help
  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    1 year ago

    Hi PC2022 ,

    Create a measure that checks if a project is selected. You can use the HASONEVALUE function for this purpose.

    ShowComments = IF(HASONEVALUE('Projects'[ProjectID]), 1, 0)

     

    Add this measure to the visual-level filters of your comments table and set the filter to show only when the measure equals 1

    You can learn more about HASONEVALUE function here 

    If this help you, please consider to accept as solution and give a Kudo.

     

    Thank you

johnt75's avatar
johnt75
Super User
1 year ago

You could create a measure like

Show Comments = IF( HASONEVALUE( 'Table'[Project ID] ), 1 )

then use that as a filter on the comments visual, to only show when the value is 1.