cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OlegV
Helper I
Helper I

show months names on x axis without aggregating data

Hello,

I have a table with prices for every day wihin a given period.

I need x axis to have Months' names only, but without aggregating data like in Ecxcel chart:

OlegV_0-1629804305189.png

 

Now I have the folowing result, an x axis have abbreviated months names with years. But I need to have only months:

OlegV_2-1629804432552.png

 

When I change from column to hierarchy and delete years and quanters, power bi does show months, but it also aggregates data. I need data to be displayed without aggregation. 

 

Is there a soluton to this? Thank you!

 

  

8 REPLIES 8
v-luwang-msft
Community Support
Community Support

Hi @OlegV ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

PaulDBrown
Super User
Super User

If the data spans several years, which non-aggregated data are you hoping to see for each month?

Do you have a date table marked as such in the model?

You can add the Year field and expand the visual to show year & month. If you turn off contatenation in the x-axis formatting options you will get the months grouped by year.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Hello,

1)"If the data spans several years, which non-aggregated data are you hoping to see for each month?"

 

No, in this case, the data spans one year. I hope to see a for each month with a day granularity.

 

2)"Do you have a date table marked as such in the model?"

 

Yes, I have a date table marked  as such.

 

3)"You can add the Year field and expand the visual to show year & month. If you turn off contatenation in the x-axis formatting options you will get the months grouped by year."

 

I have tried. What I did:

- I used a date column and changed column name to hierarchy;

- I deleted years and quaters and left only months and days;

I got this result:

OlegV_0-1629983038994.png

- after than I turned off concatenation.

Here is the filnal result...

OlegV_1-1629983118322.png

... and it is not what I need. I need to keep the day granularity, but hide days' numbers and shrink the length of an x-axis.

 

I don't think you will get anything better than what you have so far with the default line chart. You migth want to explore the custom visual store to see if there are other line chart options which offer a better alternative





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thank you for you assistance.

 

Yes. Apparently, so as to get what I need, the PowerBI team needs to add x axis options like in Excel:

- granularity of data,

- units to use

- custom formatting option.

For example, to present a date 11/03/1900 on an axis as a month "Mar".

 

OlegV_0-1630001960990.png

 

you might want to check if there is a similar request on the ideas forum and vote for it...

https://ideas.powerbi.com/ideas/ 

 

or create a new request





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






mahoneypat
Super User
Super User

Are you using your Date column as the x-axis and have it set to Continuous?  Please see this article.

Creating a simpler and chart-friendly Date table in Power BI - SQLBI

 

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hello,

Thank you for your answer.

Yes, I use a Date column with a day granularity (year, month, day) and set a type of x axis to continuous.

 

But the method in the article did not help me.

 

What I have done, after reading articles:

1) I  created a month column with a DAX formular 

Month = DATE(1900,MONTH('Brent&₽/$'[Date]),DAY('Brent&₽/$'[Date]))
2) I changed a format using custom format to "mmm". Here is the result:
 OlegV_0-1629884548550.png

 

But, It still shows "month year" on the x axis.
 OlegV_1-1629884687896.png

I need an x axis to look like I did in Excel:

OlegV_2-1629884824933.png

 

Please tell me where my mistake is, thank you!

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.