https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-categories-for-X-axis/m-p/3351052#M125834 <P>Click on the column you want to group then in column tools &gt; data groups create a new data grouping.<BR /><BR /></P> <P><img /></P> <P><BR />I prefer to work with the list grouping and specify what goes into each group. Hope this helps!</P> Wed, 26 Jul 2023 12:39:02 GMT Syk 2023-07-26T12:39:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-categories-for-X-axis/m-p/3350887#M125824 <P>Hi Community,</P><P>&nbsp;</P><P>In one of my reports I wanted to create a visual that shows the amount of days in categories. So 1to 30 days is category 01, 31-60 days is category 02, and so on. I have a solution that works, see the graph below. As you can see it shows the categories.</P><P><img /></P><P>However, to accomplish this I had to create quite an extensive formula for this, as shown below. Does anyone have any ideas for better and faster ways to accomplish this?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thanks in Advance!</P><P>Menno</P><P>&nbsp;</P> Wed, 26 Jul 2023 11:33:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-categories-for-X-axis/m-p/3350887#M125824 Anonymous 2023-07-26T11:33:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-categories-for-X-axis/m-p/3351052#M125834 <P>Click on the column you want to group then in column tools &gt; data groups create a new data grouping.<BR /><BR /></P> <P><img /></P> <P><BR />I prefer to work with the list grouping and specify what goes into each group. Hope this helps!</P> Wed, 26 Jul 2023 12:39:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-categories-for-X-axis/m-p/3351052#M125834 Syk 2023-07-26T12:39:02Z