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.
Hello,
I am having issues sorting the x-axis data on a line chart in order, when I try to convert the column for quarterly data I receive an error message.
Solved! Go to Solution.
Add a new field to your date table that would be numeric data. 201801, 201802, 201803, etc. for the quarters. Then have simlar text field in your date table that would convert to text, so it shows as you have it - Q2-17, Q3-17, etc.
Now use the new text string of quarters (q2-17) in your visuals, then in the modeling tab and use the SORT BY feature, sort those by the numeric quarter numbers above (201801, 201802, etc). That is easiest to do in the table view.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAdd a new field to your date table that would be numeric data. 201801, 201802, 201803, etc. for the quarters. Then have simlar text field in your date table that would convert to text, so it shows as you have it - Q2-17, Q3-17, etc.
Now use the new text string of quarters (q2-17) in your visuals, then in the modeling tab and use the SORT BY feature, sort those by the numeric quarter numbers above (201801, 201802, etc). That is easiest to do in the table view.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIT WORKED! Thank you!
Excellent!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering 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 |