Handling Blank in Powerbi

[Anonymous]

Hi team

Suppose in our hiearchy we have blanks from L1-L15 so in power bi we have calculated no of certificates expiring 30,60,90 days using measure and also tree based hiearchy I have used , matrix visual so there are blanks coming for example Justin
below row it is coming 70,56,90,56  what I want that Justin name should come in that blank row ss attached  and if I want to make it dynamic how to do?

I have tried drill down and coalesce dax feature but none is working 

attaching screeshot for the same is it possible to do or it will be tedious task.

please help me to resolve the issue as soon as possible

[v-veshwara-msft]

Hi @Anonymous ,

We’re following up once more regarding your query. If it has been resolved, please mark the helpful reply as the Accepted Solution to assist others facing similar challenges.

If you still need assistance, please let us know.
Thank you.

[v-veshwara-msft]

Hi @Anonymous ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @Anonymous ,

Just checking in to see if you query is resolved and if any responses were helpful. If so, kindly consider marking the helpful reply as 'Accepted Solution' to help others with similar queries. 

Otherwise, feel free to reach out for further assistance.

Thank you.

[v-veshwara-msft]

HI @Anonymous ,

Thnaks for reaching out to Microsoft Fabric Community and thank you @rajendraongole1  for the helpful response.

Since you've already tried COALESCE and drill-down, the measure using ISINSCOPE shared by @rajendraongole1 is the best way to show the correct level name alongside your data. It won’t change the row headers, but it can help make the blank rows clearer by displaying the name in the value area.

Hope this helps. Please reach out for further assistance.

Please consider marking the helpful reply as Accepted Solution and giving kudos to assist others with similar issues.

Thank you.

[rajendraongole1 · Accepted solution]

Hi @Anonymous - You cannot dynamically change the Row Header in a matrix based on a measure.

you can use ISINSCOPE with Measures for Custom Display as below:

Display Manager =
SWITCH(
TRUE(),
ISINSCOPE('YourTable'[L15]), 'YourTable'[L15],
ISINSCOPE('YourTable'[L14]), 'YourTable'[L14],
ISINSCOPE('YourTable'[L13]), 'YourTable'[L13],
ISINSCOPE('YourTable'[L12]), 'YourTable'[L12],
ISINSCOPE('YourTable'[L11]), 'YourTable'[L11],
ISINSCOPE('YourTable'[L10]), 'YourTable'[L10],
ISINSCOPE('YourTable'[L9]), 'YourTable'[L9],
ISINSCOPE('YourTable'[L8]), 'YourTable'[L8],
ISINSCOPE('YourTable'[L7]), 'YourTable'[L7],
ISINSCOPE('YourTable'[L6]), 'YourTable'[L6],
ISINSCOPE('YourTable'[L5]), 'YourTable'[L5],
ISINSCOPE('YourTable'[L4]), 'YourTable'[L4],
ISINSCOPE('YourTable'[L3]), 'YourTable'[L3],
ISINSCOPE('YourTable'[L2]), 'YourTable'[L2],
ISINSCOPE('YourTable'[L1]), 'YourTable'[L1],
"Unknown"
)