Microsoft Power BI Desktop Forum

This is a community forum and not official technical support. — If you need official support: Contact Us

The following comments are owned by whoever posted them. We are not responsible for them in any way.

Back to Threads Reply to Thread

filling blanks with previous row in matrix visual

Hi,
I have a report as illustrated in the link given below.

As shown there is no data from 2018-01 till 2018-11 for second hieracrchy.
In case of any blank,I want to replace it with the data in previous row and extend it till last week so that there is no blank row and there exists data across every week

Please find the link of the file below:
https://drive.google.com/open?id=1z5iScgQ__2K3r-xKiCUci36xdJRL7ETX

CrossOver Forums: the place to discuss running Windows applications on Mac and Linux

CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.
Please Wait...
eyJjb3VudHJ5IjoiVVMiLCJsYW5nIjoiZW4iLCJjYXJ0IjowLCJ0enMiOi02LCJjZG4iOiJodHRwczpcL1wvbWVkaWEuY29kZXdlYXZlcnMuY29tXC9wdWJcL2Nyb3Nzb3Zlclwvd2Vic2l0ZSIsImNkbnRzIjoxNzMxNDM1MjAzLCJjc3JmX3Rva2VuIjoiS1VCQ05LOEFScDlYd3VBOCIsImdkcHIiOjB9