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.
Hello ,
I have the below graph and I need to show on Axe X only all months
But my problem that when I choose
I have the below graph:
So I have the sum of all months …, can someone help me to display the first graph with only all months and without calculate the sum.
Thanks for your help
Hi ,
Any help please ?
Hi @mellas_k,
Change the X-axis type to Continuous as is shown in above screenshot will show all twelve months on axis. So what did you mean 'see all the months' and what is your current result after setting type to Continuous?
Best regards,
Yuliana Gu
When i change the X-axis i have the below result
And i need to show all 12 monthes ..
thanks for your help.
Hi @mellas_k,
Please try to new a calendar table and create a one to many relationship to source table. Then, in chart visual, add date column from calendar table to X-axis. Repeat all above operations.
Regards,
Yuliana Gu
If I understood correctly what you means ..
i create a new table , i create a relation between it and source table , but always i have the same issue ....
i can only see 4 or 5 months
Best regards;
Hi @mellas_k,
You could try enlarge the width (drag the right margin manually) of the chart visual to make all months available on X-axis.
Regards,
Yuliana Gu
Hi @mellas_k,
Could you try this workaround:
Create a calendar table:
Dim date = FILTER( CALENDAR(DATE(2016,1,1),DATE(2017,12,31)),DAY([Date])=1)
Union this calendar table and source table:
Union table = UNION ( ADDCOLUMNS ( 'Dim date', "Sales", 0 ), SELECTCOLUMNS ( 'SourceTable', "Date", 'SourceTable'[SalesDate], "Sales", 'SourceTable'[SalesValue] ) )
Drag date column and sales column from the union table into chart visual. Set X-axis type to categorical.
Regards,
Yuliana Gu
Hi
Try to use Format And Month functions to get the month name and then use it as the x axis’s.
Hi
what if you change the graph formatting as below, (drill down up to date level but the date want shows up. I think this came up with a new update, if you don't see it please update power BI desktop to latest version.
HI @dilumd
thanks for your answer , yes i did it but my boss wants to see all the months ..
i have not the choice ..
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |