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 Team,
Can some one help me why the monthe name is showing difference between Table and Chart. I have calculated the month using the EOMONTH function. The November Month data is showing as December in Charts which is wrong.
Solved! Go to Solution.
When a column is of date type and on x axis of a column chart, it will choose Continuous type for x axis by default and adjust axis text automatically instead of showing the exact values in the column.
To change the axis text, one workaround is to change x axis type from Continuous to Categorical. Another is to change this column from Date type to Text type manually (or using Format function as Amit has suggested because Format function returns value in Text type too). Both will display exact column values on the axis.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
When a column is of date type and on x axis of a column chart, it will choose Continuous type for x axis by default and adjust axis text automatically instead of showing the exact values in the column.
To change the axis text, one workaround is to change x axis type from Continuous to Categorical. Another is to change this column from Date type to Text type manually (or using Format function as Amit has suggested because Format function returns value in Text type too). Both will display exact column values on the axis.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@RanjanThammaiah , Hope you have done like
Month year = format(eomonth([Date], 0), "mmm-yyyy" )
0 for current month end date
This is how i have been added the month end date, is there anything wrong?
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |