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 ,
I’ve used a general example where the data structure includes three columns. When I drag and drop these columns into a matrix (or table) visual to replicate a similar scenario, blank value columns in the matrix or blank rows in the table do not appear.
You might want to double-check your data structure and also ensure that the data type for the "Value" column is defined correctly.
I hope this helps! If not, please feel free to share more details about your current data structure or confirm whether you're using measures.
Thank you!