I need some help on the P&L for different entities. I already watch the Financial Reporting with Power bi. However, that was only for one entity. What if we have different entities and also some of the entities have some different accounts compared to the other. But we want to make only based on one template. I try to play around with the file given. However, I couldn`t get the right P&L looks for them. As if we use one template for all, the account will be still there. Let say, all the other part has done. The only part that we need to figure out is the template part. One template for all but we only show only one template if we select one entity.
This is the problem I encounter, I choose one entity, but this account below in the picture still appears in the template. How can we remove it. We can simply remove it by filtering at filter pane but it will not be efficient and also we could not compare this year and last year. maybe the account exists last year but not this year.
Hi @Amirul, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.
Use the forum search to discover if your query has been asked before by another member.
When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
Use the proper category that best describes your topic
Provide as much context to a question as possible.
Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.
Hi @Amirul, we’ve noticed that no response has been received from you since the 2nd of March. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, and any other supporting links and details.
In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
This is from the Financial Reporting Courses in Enterprise DNA, however, i made a slightly changes on the data table, which I remove some amount for certain years. So, then after i removed , i found that the visual will be showing the empty rows.
Hi @Amirul! We noticed that your inquiry was left unsolved for quite some time now. We strive to answer ALL inquiries in the forum. However, if you are sure that you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, you can check out tutorials to learn this yourself as your membership also comes with relevant resources that may help you with your Power BI education.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!
