Forum Discussion
Matrix visual to show rows without values
Hi, I'm trying to create a matrix visual that shows all customers even if they don't have any sales figures. And I want it to work with a date slicer. The vision I'm trying to reach is something ...
Hi ErikHolmberg
The formula is as simple as
[Total Sales] + 0But make sure you use the column Client dimension table as if you use the one from your fact table and there isn't a row for that client within the range selected, that client will not appear even if your rewrite your formula to return 0 if sales value is blank.