https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3234014#M118770 <P>- don't show values as percentages</P> <P>- switch your x axis from categorical to continuous.</P> Sun, 14 May 2023 00:43:53 GMT lbendlin 2023-05-14T00:43:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3229835#M118484 <P>I am trying to replicate this x-axis view. However, it shows like this everytime I drag year and month in x-axis in my line graph:</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Desired output:</P><P><img /></P><P>Any tips to do this quickly or easier? Thanks in advance</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 11 May 2023 05:35:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3229835#M118484 ironboy0418 2023-05-11T05:35:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3234014#M118770 <P>- don't show values as percentages</P> <P>- switch your x axis from categorical to continuous.</P> Sun, 14 May 2023 00:43:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3234014#M118770 lbendlin 2023-05-14T00:43:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3239339#M119143 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="100342" data-lia-user-login="lbendlin" class="lia-mention lia-mention-user">lbendlin</a>&nbsp;it needs to be on percentages. on the other hand, how can I switch it to continous?</P><P>Thank you</P><P><img /></P><P>&nbsp;</P> Wed, 17 May 2023 04:00:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3239339#M119143 ironboy0418 2023-05-17T04:00:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241051#M119249 <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 17 May 2023 20:51:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241051#M119249 lbendlin 2023-05-17T20:51:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241110#M119252 <P>No options in me like this, maybe its already continous data?</P> Wed, 17 May 2023 22:42:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241110#M119252 ironboy0418 2023-05-17T22:42:09Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241156#M119255 <P>what is the data type of the field in the x axis?</P> Thu, 18 May 2023 00:06:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-show-year-and-then-month-as-x-axis-in-line-chart/m-p/3241156#M119255 lbendlin 2023-05-18T00:06:26Z