show months names on x axis without aggregating data

[OlegV]

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:

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

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!

[v-luwang-msft]

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]

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.

[OlegV]

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:

- after than I turned off concatenation.

Here is the filnal result...

... 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.

[PaulDBrown]

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

[OlegV]

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".

[PaulDBrown]

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

[mahoneypat]

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

[OlegV]

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:

 

But, It still shows "month year" on the x axis.

 

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

Please tell me where my mistake is, thank you!