Report Migration to Power BI

Power BI
1

Hi All,
I am migrating a report from a system to Power BI but the challenge i am facing is that the report os growing horizontally.
I am attaching the sample of my report where the report is extending by one column each day.

I know by having the data hierarchy the report can be shrinked but the users of the report wants same report which was existing earlier,So,how can we improve the existing report.

It would be helpful if anyone can suggest any new way so the report can be improved.

Thanks
Sample_Sheet.xlsx (8.7 KB)

2

To ensure that all topics posted contain all necessary details for a faster and more accurate solution, posts are subject to review; please allow 12-24 hours for approval.

Use the forum search first to discover if your query has been asked before by
another member.

Provide the following:
• Details and images of the scenario, problem, screenshot of the data model, MASKED demo PBIX file, desired result in detail, and other supporting details relevant to the problem.
• Refer here: https://forum.enterprisedna.co/t/how-to-mask-sensitive-data-in-power-bi/7788
• When posting a topic with DAX CODE, make sure that it is correctly formatted to preformatted text

–

Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a like.

3

Hi @Jacob_M,

The primary improvement for the data structure would be to flip the column and row headers, such that each new date added is a new row. This would then allow the visualizations in Power BI to work optimally, including optionally applying a date hierarchy and using a simple table to display the data. Specific visuals like a column chart or line chart could still keep the dates horizontal if that is what users need/prefer.

John

1 Like
4

Thanks for your reply but the client need to have the dates as column.

On the other hand,I found one more problem with column data as dates :
Matrix visual has Limitation of 100 column .

I cannot use custom visual as well .

Can anyone please suggest how can i manage more than 100 columns in “Power BI Matrix Visual”?

5

@Jacob_M,

Perhaps using a paginated report instead of a Power BI report would work better? Or you could use a matrix/table visual and use slicers to select a moving 100 date (i.e. column) window. It depends on what you need to do with the data, how you need to query it from the source, etc. I can see that the dates being added are not contiguous, and it would be helpful to see examples of the values under each date. Could you provide a sample PBIX along with how you are sourcing the data? And also indicate whether you are on-prem (PBRIS) or hosted (Power BI service).

John

1 Like