Forum Discussion

KarthikSridaran's avatar
KarthikSridaran
Frequent Visitor
10 years ago
Solved

How to use Date field as Values in Matrix?

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 coun...
  • jahida's avatar
    jahida
    10 years ago

    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).

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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.