Column Issues with Matrix Report

DAX DAX Calculations
1

Hi all.
I have a Matrix report with multiple columns level. One of these columns has an empty row and users want this column removed from the report. But because of the underlying source data, I could not remove this column as it is dynamically grouped with other columns:

image
image982Ă—608 35.1 KB

I will appreciate it if there is a workaround for this situation.
The column I want to exclude or remove is Required column under the main column header REFUSED
File attached:
Thank you
ColumnIssues.pbix (58.8 KB)

2

Hi @upwardD,

See if this is acceptable.

  1. Hide the column by minimizing it
  2. Disable “word wrap” on header and values

image
image746Ă—555 39.4 KB

I hope this is helpful

4 Likes
3

Beautiful!
Thank you @Melissa

1 Like