user_dilFrequent Visitor3 years agoSolvedCustomised Dates Hi All, I'm trying to create a simple line chart with a customized date format using as the X-axis. Date type: Dec 1- Th, Dec 2-Fr, ....., Jan 31-Tu, Feb 1-We, Feb 2-Th likewise up to current d...Show MoreFreemanZ3 years agohi user_dil you can get the column with one step, like:Column = FORMAT([Date], "mmm-dd") &"-"& LEFT( FORMAT( [Date],"ddd"), 2) to sort a visual, you can still pull the original [date] column to the tooltip of the visual and use the [Date] column to sort the axis.
FreemanZ3 years agohi user_dil you can get the column with one step, like:Column = FORMAT([Date], "mmm-dd") &"-"& LEFT( FORMAT( [Date],"ddd"), 2) to sort a visual, you can still pull the original [date] column to the tooltip of the visual and use the [Date] column to sort the axis.
FreemanZ3 years agohi user_dil you can get the column with one step, like:Column = FORMAT([Date], "mmm-dd") &"-"& LEFT( FORMAT( [Date],"ddd"), 2) to sort a visual, you can still pull the original [date] column to the tooltip of the visual and use the [Date] column to sort the axis.
FreemanZSuper User3 years agohi user_dil you can get the column with one step, like:Column = FORMAT([Date], "mmm-dd") &"-"& LEFT( FORMAT( [Date],"ddd"), 2) to sort a visual, you can still pull the original [date] column to the tooltip of the visual and use the [Date] column to sort the axis.
Related contentHow to customise sorting range values in Matrix?Customising themesPower BI Alerts CustomisationPBI Desktop Customising SlicerLine chart customisation
