Forum Discussion
How to remove a column from a nested matrix table
Hi abdullahtunn
If Budget, Forecast, Plan, and Actual are measures, they wil remain visible regardless they have a value or not. You can use a disconnected table with a column containing the measures names and another measure to assign the original measures' values to that column. The table below was created using enter data. Format string is necessary if the measure have different format (eg., whole number vs percentage).Create dynamic format strings for measures
Note: I intentionally exluced L A T A M in from the measure as I don't have a sample data that may return blank only for a specific category.
Notice in the image below that there's no visible column for L A T A M- Volume
Please see the attached pbix
Hi abdullahtunn
If Budget, Forecast, Plan, and Actual are measures, they wil remain visible regardless they have a value or not. You can use a disconnected table with a column containing the measures names and another measure to assign the original measures' values to that column. The table below was created using enter data. Format string is necessary if the measure have different format (eg., whole number vs percentage).Create dynamic format strings for measures
Note: I intentionally exluced L A T A M in from the measure as I don't have a sample data that may return blank only for a specific category.
Notice in the image below that there's no visible column for L A T A M- Volume
Please see the attached pbix
One last thing, can I add comments at the end of my Matrix table? When I add those, either they come under rows or are scattered in the columns. I want to add them separately at the end of the matrix table?