Power BI Matrix is not showing the column with no data

[rkrt1]

Hi folks,

Just wondering if anyone can help me out with a solution, it would be a great help.
I have a matrix visual with dates and data to show. I want to see the column as blanks which has no data but is not showing up and hiding the dates having no data.

Now


Required table view with all dates:





Using this measure to show the data in the column to concatenate multiple events happening on the same date for different IDs.

Column Data =
IF(
HASONEVALUE(Dim_data[ID]),
CONCATENATEX
(
'Fact Table',
'Fact Table'[Column Data],
UNICHAR(10)&UNICHAR(13) ,
'Fact Table'[Column Data]
)
)

 

[p45cal]

Duplicate thread:

Power BI Matrix visual: Column date is hiding when data doesn't exit. Please help!!

Hi folks, Just wondering if anyone can help me out with a solution, it would be a great help. I have a matrix visual with dates and data to show. I want to see the column as blanks which has no data but is not showing up and hiding the dates having no data. Now Required table view with all...

forums.excelguru.ca