Forum Discussion
Matrix Visual: Onyl show rows with data on lower level
Hey,
i have an question about the matrix visual.
I have a matrix which is about ongoing projects for customers. In every row, there are 4 levels: concern, company, project, subproject. There are some collums about date, budget, project owners...
Some concerns / companies dont have any projects/subproject. My goal is to show only the concerns/companies(level 1/2) with projects (on level 3/4).
The customers(concern/company) are in an extra table, linked with a 1 to many relationship to the project table. This relationship uses an ID. In the projects table, there only is this ID of the companies.
Has anyone an idea?
Thanks for your help!
Hi Anonymous ,
You can refer the following links to get it:
Create a Power BI Dashboard for Microsoft Project Online
Data Analysis for Project Managers with Power BI
How do I create a report which shows running, new, ending and ongoing project in a given period
If the above ones can't help you, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples in order to give you a suitable solution. It is better if you can share a simplified pbix file. Thank you.
Best Regards
1 Reply
Hi Anonymous ,
You can refer the following links to get it:
Create a Power BI Dashboard for Microsoft Project Online
Data Analysis for Project Managers with Power BI
How do I create a report which shows running, new, ending and ongoing project in a given period
If the above ones can't help you, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples in order to give you a suitable solution. It is better if you can share a simplified pbix file. Thank you.
Best Regards