When creating my financial income statements, I need to filter by business line. However, since not all business lines have values in their concepts, some rows disappear when filtering by business line, including calculated rows such as EBITDA, Operating Income, etc.
How can I keep the rows fixed even if they have no values, so that filtering does not cause this issue? I am attaching pictures showing how it looks without filtering by business line and how it looks after filtering by some business lines.
- Without Filtering:
- Filtering:
2 Comments
Hi Dapoblete ,
You may try use a measure to handle missing values like create a measure that returns a value (e.g., 0) when the row has no data. This way, the row will still appear even if it has no values.
Or you may adjust the matrix settings. and ensure that the matrix settings are configured to show items with no data. This can be done in the matrix visual settings under the "Values" sectionBest Regards,
Community Support Team _ Caitlyn- Hi Caitlyn, I tried the first option with this mesure, but still doesnt work: Nuevo Monto = VAR ValorReal = SUM('MAYOR'[MONTO]) RETURN IF( ISBLANK(ValorReal), "N/A", ValorReal) And the second option doesnt work too, the matrix still contract when i filtering. Maybe its a visual object issue or my mesure is wrong. Please your help. Thanks and best regards.
