Get each value of X-Axis in continous format

[andreazambon]

Hi there. 

In order to see a trend line, I set the X-Axis with Months in continuous mode. 

But in this configuration, I lost the number of the months for each barrel in my graph:

There's a way to obtain this detail?

Thanks.

[Anonymous]

HI @andreazambon,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[andreazambon]

Hi, here you have an example:

https://we.tl/t-TLwboHA62u

As you can see, months starts from 0 (but month 0 does not exist) anche not all the columns has the properly enumeration.

[Anonymous]

Hi @andreazambon,

Do you mean the trend line also need to expand and trace each line? AFAIK, current power bi trend line does not support this. Perhaps you can submit an idea for add support with this requirement.

If your line is based on measure expression, you only need to add a filter to it to check the current category values.

Regards,

Xiaoxin Sheng

[andreazambon]

Hi @Anonymous, 

no, I mean that in X axis I want to see the value for each month. In the example I provided we can see 0,4,6,8 (means 0=? 4 =April, 6= June, 8 = August), but in other graphs I have situations like 0-5-10. 

I need to see the correct month number for each column: I need a situation like 1-2-3-4-5-6-74-8-9-10-11-12.