Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a question in which I want my date format in my visualisation to "MMM-YY", I know I can make use of the following DAX to perform and get the format I want:
=FORMAT(Data[Date],"MMM-YY")
However, the above format will convert the Date into a Text. This become a problem in which my Visualisation will not show in the sequence of the monthly order. For example, you notice from the following graph in which the order run out because date become a text format.
Any idea? thanks..Tuff
Solved! Go to Solution.
Select a column in Fields. Then go to Modelling tab. Go to Sort by column and select the desired column to be used in sorting selected column.
Hi @Anonymous ,
Create another column like
Hi ORBI,
I had created a calculated column with the text format (YearMonthShort) I want and this column refer to another column (Reporting Month) in my query.
Hence, how do you sort and how do you sort in the visualisation? Thanks
In DataView. Once click on any column. You will sort on column View. Click on this column and choose the sort column.
There best sort column for month year is YYYYMM. Create it using format.
Select a column in Fields. Then go to Modelling tab. Go to Sort by column and select the desired column to be used in sorting selected column.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |