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.
Since the Sept 2022 update I have issues with the X-axis of my line charts. Chart 1 shows what the chart looked like before the update. The chart is showing the results of testing conducted at multiple dates across the past year. It uses a legend which is the Test Summary. The data used in the chart is structured per the example in Table 1 (dummy data).
Since the Sept 2022 update, the chart instead looks like Chart 2 both in Power BI Desktop and the Service. I've tried turning on/off the "concatenate labels" option for the X-axis, adjusting drill down levels, etc. (see Charts 2 to 4) and I cannot recreate Chart 1. The chart appears as desired until I add the "Test Summary" field to the legend.
Is there any way I can recreate Chart 1 post Sept 2022 update? Is this a bug I can report somehow? Any help greatly appreciated, thank you!
Table 1 - Data Structure Example
Chart 1 - Prior to Sept 2022 Update:
Chart 2 - After Sept 2022 update (default behaviour - concatenate labels on)
Chart 3 - After Sept 2022 update (concatenate labels off)
Chart 4 - After Sept 2022 update (concatenate labels off, Month drill level)
Solved! Go to Solution.
Oh, mabe in new version, the option does not exist. Try turn of "Auto to Date/Time" in Setting.
Hi
Try to select "Continous" in Type of X axis
Thanks for the reply. Unfortunately once I add in the "Test Summary" column into the Legend, the X-axis formatting options change from Continuous/Categorical to the below options:
Oh, mabe in new version, the option does not exist. Try turn of "Auto to Date/Time" in Setting.
Yes! Turning off "Auto date/time" seems to have worked. Thank you very much 🙂
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |