Forum Discussion

Rnaval's avatar
Rnaval
Post Partisan
2 years ago
Solved

Need help with a Matrix Visual

I have an Excel file with Programs and the Projects that roll up under it. I created a Matrix Visual for this but it's not working as expected. I want to list the program name only without any associ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Rnaval ,

     

    Based on my understanding, it seems like you are working with a spreadsheet that has multiple tabs and you are using drill-through pages to display data for programs and projects. It sounds like you want to know if you can use the same tab in the spreadsheet for both the program drill-through and the primary data, and pull the data from the first line of the program name. Without knowing the specifics of your spreadsheet and data structure, it's difficult for me to give a definitive answer. However, in general, it is possible to use the same tab in a spreadsheet for multiple purposes and pull data from specific cells or rows based on certain criteria.

     

    Please create a new thread to provide detailed information and other questions, there will be more engineers and users to help you.

     

    Best Regards,

    Neeko Tang

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Rnaval ,

 

According to your description, you want no information to be displayed when you are at the Program / Project Name level in the matrix, and detailed information to be displayed when you are at the Project Name level, right?

 

Here we create a measure using the example of displaying Agency information.

 

Agency Measure = IF(ISINSCOPE('Sheet1 (2)'[Our Project Name])=FALSE(),BLANK(),MAX('Sheet1 (2)'[Agency]))

 

Best Regards,

Neeko Tang

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

Rnaval's avatar
Rnaval
Post Partisan
2 years ago

Thanks...Is it possible to suppress the data in the columns even when the program \ project level is collapsed?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Rnaval ,

     

    Sorry I don't quite understand what you mean, as my screenshot shows, the Agency doesn't show the data when the program \ project level is collapsed.

     

     

    Best Regards,

    Neeko Tang

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

    • Rnaval's avatar
      Rnaval
      Post Partisan
      2 years ago

      Here's a screenshot showing all columns having data when the program name is collapsed.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Rnaval ,

         

        Due to the design, it is not supported to directly have columns not display data when collapsing the program name. You need to create measures to place on the visual object instead of columns.

         

        Best Regards,

        Neeko Tang

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