Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Handling Blank in Powerbi

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 , matr...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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"
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.