Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 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.
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).
@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.
Really? because I tried it on mine and it worked... Are you sure you're making it a measure and not a column?
@jahida I am very sorry I tried creating a column , It worked fine after making it as Measure. Thanks 🙂
All good, glad it worked 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |