Forum Discussion
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.
Hi hainguyen28,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.