Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

Dot plot graph: Chronological arrangement of the values

Hi guys 🙂


I need your help again 🙈 There ist the picture of dot plot graph. As you can see the values (years) on the x-axis are so random but I need a chronological arrangement of the values on the x-axis. Any ideas how to get it? Thank you very much!

Best regards

 

Screenshot 2022-09-27 113857.png

2 REPLIES 2
TMO_KY
Helper II
Helper II

@nirvanakarolina  first question, are you using a date table or the native dates within your datasource?  If you're not using a date table, I highly recommend it.  Here's the one I use from RADACAD along with an amazing write up on it: RADACAD - Date Table 

Secondly, if you use the data table from RADACAD or any other calendar table, under the "Data" tab on the left of BI Dekstop, go to your calendar table and select the column(1) you will be using in the X-axis and then click the sort(2) column another column (whichever one works for you, typically it's the date column.

TMO_KY_0-1664373927187.png

 



Alternatively, you can try to hover the visual, click the 3 dots ... and sort that way, sometimes that doesn't always work

TMO_KY_1-1664375064491.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.