How to use Date field as Values in Matrix?

[KarthikSridaran]

Hi,

I wanted to view a DATE field as a value under Matrix visualization.

I have attached an image like how i am trying to implement. 

But in Power BI the values are either summarized by count or count(distinct).

Help me how can i bring the date into the column as it is.

Thanks in advance,

Karthik 

[ankitpatira]

@KarthikSridaran any column you drop onto Values section is meant to be an aggregate. The closest you can get to what you want is drop date column on both column and values section which will give you result as below.

[jahida · Accepted solution]

Can you make a really simple measure to substitute?

Measure = FIRSTDATE('Table'[Column])

The problem with bringing in a column is PowerBI can't be sure that there won't be multiple values for a given spot, so the measure provides an aggregation in the case that there is more than one (even if there never will be).

[KarthikSridaran]

@jahida, even the FIRSTDATE(Table[Column]) is considered as Count or Count(distinct) if it is used as a Value in Matrix visuatization.

@ankitpatira If the Value part is always aggregate then i am left with an option of changing the visualization as you said or to something better.

Thanks guys.

[jahida]

Really? because I tried it on mine and it worked... Are you sure you're making it a measure and not a column?

[KarthikSridaran]

@jahida I am very sorry I tried creating a column , It worked fine after making it as Measure. Thanks 🙂

[jahida]

All good, glad it worked 🙂