Customized data display in matrix not shown when data is empty

Thank you, lbendlin , for your response.

Hi hainguyen28,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and the code, which may assist in resolving the issue:

Total Sales Last 13 Months =

VAR SelectedMonth = MAX('Calendar'[Date])

VAR SalesAmount =

CALCULATE(

SUM(Orders[Sales]),

DATESINPERIOD(

'Calendar'[Date],

SelectedMonth,

-13,

MONTH

)

)

VAR TotalSales = [Total Sales]

VAR SalesPercentage = DIVIDE(SalesAmount, TotalSales, 0)

VAR ProductCategories = VALUES('Orders'[Product Category])

RETURN

IF(

ISBLANK(SalesAmount),

BLANK(),

CONCATENATEX(

ProductCategories,

SWITCH(

TRUE(),

'Orders'[Product Category] = "Furniture", FORMAT(SalesAmount, "#,##0"),

'Orders'[Product Category] = "Office Supplies", FORMAT(SalesPercentage, "0.00%"),

'Orders'[Product Category] = "Technology", FORMAT(SalesAmount, "0.00"),

FORMAT(SalesAmount, "0.00")

),

", "

)

)

If you find our response helpful, kindly mark it as the accepted solution and share your appreciation. This will support other community members facing similar queries.

Thank you.