Formatting Data from three tables into a dynamic report
Hi, I have three data tables I'm trying to combine into dynamic reports. They are contain unique ID keys so the relationships are in place, but I'm having trouble dispaying them in a way that is flexible enough and not incredibly complex to set up. Table 1 contains projects with various fields Table 2 contains the leads for the projects, with various fields including the project ID corresponding to table 1. Each project will have exactly 1 lead and each lead will only have 1 project. Table 3 contains other team members with various fields. There will be at least one in addition to the lead for every project, but often there will be more than one, up to around twenty. This table contains the ID for the project and lead each team member works with, and no team member will ever have more than one project/lead. I'd like to combine these into a report in a format like: Header with all project fields Project 1 Header with all lead fields Lead for project 1 Header with all team member fields Team member 1 of XX for project 1 Team member 2 of XX for project 1 .... Then the same for project 2 and so on. I can see how I would do this with code, or with a really complicated spreadsheet with lots of counts, lookups and helper collumns, but I'm hoping Power BI can help me find a simple-ish solution. Thanks for any advice!Problems in table relationships (value don't appear)
Problems in table relationships I have two fact tables and two dimensions (date and accounting account), I have to make the relationship to integrate the information. One of the fact tables has the values for 2021 because it is real data and the other fact table is for budget data, so they are for 2022. When I make the relationship only between the date table, the separation is done by months, correctly. When I make the relationship only by the ledger account, the separation is also made looking only at this parameter. However, when I make the relationship between the two dimension tables, the date one unconfigures and the values of the "fDespesas_Payments" table do not appear. When I break it down by month and year, by month it does the division, but when I put the year of "2022" there is no information, it comes values only for "2021" which refers to the real data. Could you help me please?Table Row Height not showing full data for field
I have a table that has a large field and when viewing on the report server the height of the row does not show the full extent of the data for that field. If you adjust the width for that column then all of the data is displayed correctly. I've tried adjusting the settings in the desktop software with no luck getting this fixed. Thanks. Table on load: Table viewing the same record after adjusting column width:
Suppressing rows in a table
I am brand new to Power BI and I wish to do the following. I have a table of open text comments from a survey, there can be one or more comment per respondent. If, after filtering the data by one or more demographic, there are fewer than 5 respondents then I wish to suppress the comments and display a message saying something like 'There are too few respondents to display any comments'. So far I have been unable to determine how to do this, can it be done? If so, how?
