Forum Discussion
Post PartisanNeed Help - with a drill through page
Hi Rnaval ,
It seems that the problem you describe is caused by the interactions of visuals. Please try to change the way the charts interact with each other:
Besides, this question is beyond the topic of discussion at the beginning of this thread, so please consider marking the responses that are helpful to you and creating a new thread about the new question, which will make the question more relevant and allow more people to help you. It will also help other people with the same problem.
Thanks in advance!
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Rnaval ,
Because the data in the table you want to Drill Through contains multiple matching values, it is impossible to tell which one is the one that needs to be displayed, so if you want to display the value of the top row, you would be better off aggregating the first row of each Project/Program into one table and using the data from this table as the target table for Drill Through.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RnavalI had tried that originally and just tried it again as you suggested but cannot get the matrix to work properly where the projects would show rolled up into the program. Any chance you can try updating it yourself to show how this should work?
- Rnaval
Hi v-jianboli-msft ,
I was able to resolve the issue using your suggestions. Now I have another question, the two graph visuals on the right side of the page - Current Projects by Status and Current Projects by Phase - these graphs don't behave properly when you're filtered, can you suggest what I need to do to fix this? Basically, I just want the graphs to look the same but with smaller counts as a result of the filtered values. However, I'm seeing additional colors and lines being introduced when I do that?