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.
My year is coming out as a 6-digit number. I created a calendar with calendar auto and then added a year column with Year = Year('Date'[Date]). How can I make it a four digit year? It worked in a table visualization yesterday but in a new table today in the same pbix file it is coming out as a 6 digit year.
Solved! Go to Solution.
Within your visual you probably have an implicit measure so it is probably summing up all your year values. In the visual click the drop down for the field and click dont summarise. Also select the field and under the modelling tab change the default summarisation to do not summarise.
Within your visual you probably have an implicit measure so it is probably summing up all your year values. In the visual click the drop down for the field and click dont summarise. Also select the field and under the modelling tab change the default summarisation to do not summarise.
Yep - it was summarizing! I had gone back and changed the column to format as "yyyy" and that worked but your solution is easier.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |