The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hello there,
I making a line graph to show sales of 2018 and 2019. I created a date table and I related this to dates in sales table.
I want the graph looks like this
But when I put date in the axis it looks like this
I put a column in the date table of months, year and days but in the case of January it sums january of 2018 and 2019
Hope you can help me.
Thank you.
Solved! Go to Solution.
Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.
Dear All
Good Day
I am having the Same issue
I am having a Data table As below of Weeks & values (in terms of Weekly Value & Accumalative Value),( I am Plotting the **bleep** Columns Column No.7,8,9
When i use a Line Graph it is shown like Below (Which is what i need) but remaining is to show the rest of the Months (Like Feb,April, Aug,ETC)
I Have Formated the weeks to show me Month & year only using this fromula
Kindly I need your Support
Try changing the x-axis setting from Continuous to Categorical in the Format pane.
I tried what you say but it shows me every day of the calendar, and if I put months on the axis box I have the same problem in January that sums sales of january 2019 and 2018.
Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |