Forum Discussion
Matrix Background Color
Hi Anonymous ,
You can refer the following threads to get it:
Display zero instead of blank in matrix
Hi, you can obtain this view following these steps:
1.Create a new Table (Modeling-New Table)
Tablepr=Distinct(Table1[pr]
2. Related both tables
3. Create the Measure to Count IDs
CountIDs=Count(Table[id]) + 0
unable to replace blank with zeros in matrix
As @Fowmy points out, if there are no rows in the data table corresponding to a particular cell, then it can't return anything since there's nothing to evaluate. It doesn't matter if you add "+0" to the measure since it never gets called in the first place.
The solution to this is to use dimension tables to populate the rows and columns in the visual. I.e., a date table for the rows and some sort of index table for the columns. This way, the measure you put in the matrix cells lives in the cross-join of the dimensions rather than being limited to the subset that intersects with your data table.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Thank you! With that I filled in what was missing but does not paint me in green the cases in 0, how could I do in this case?
Hi Anonymous ,
In order to give you a suitable solution, could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards