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

KarthikSridaran's avatar
KarthikSridaran
Frequent Visitor
10 years ago

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's avatar
jahida
Icon for Impactful Individual rankImpactful Individual
10 years ago

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

  • KarthikSridaran's avatar
    KarthikSridaran
    Frequent Visitor
    10 years ago

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

    • jahida's avatar
      jahida
      Icon for Impactful Individual rankImpactful Individual
      10 years ago

      All good, glad it worked :)