Metrics drill down for Date hierarchy is not working as expected

[Anonymous]

Hi,

We are working on metrics drill down report. Below is the output expected in the Power BI report.

Expected Output <Table 1>

<<Please refer to image attached>

Power BI View: <Table 2>

<<Please refer to image attached>

Date hierarchy and Type is coming from one table and Project Name and BU is coming from another related table.

We have used the following measures to display the Type, Project Name and BU values in the power BI report.

Test_Project_NAME = CONCATENATEX(VALUES('Type'[Type]),'Type'[Type], UNICHAR(10))

Test_milestoneType = CONCATENATEX(VALUES('Project Name'[Project Name]),'Project Name'[Project Name],UNICHAR(10))

When we drill down the hierarchy at day level it looks ok and we get the expected output as shown in table 1. But, when we move to the Month/Quarter/year level it breaks i.e. shown in table 2. If the project is available against multiple Type it is merged and shown against one Type, similar for the BU column (Shown in Table 2)

Please let us if the measure is written correctly to get the Type, ProjectName, and BU details or there is some limitation for the metrics report to display the hierarchy for multiple columns from the related table.

Thank you.

[lbendlin]

I can't. Power BI doesn't work like Tableau. My recommendation is that you stop "fighting the API" and embrace the Power BI paradigms.

[lbendlin]

It does exactly what you asked it to do.  Do not concatenate the values if you want to see them in separate matrix cells. You will not be able to create your desired table 1 in Power BI, that is not how Power BI works (no merged cells)

[Anonymous]

Hi,

Can you please help me to write the measure if I want to see in a separate metrics cell. The way Tableau reporting showing in table 1.

Thanks.