DAX formula and using on line chart with continuous date axis

Question

Hi,&nbsp;I want to use this dax formula and display it in a YoY line chart. But I cannot get the x axis to display the points continuously, so the chart is very long. Can smeone help?&nbsp;Measure 2 =CALCULATE (sum ( 'nrtp.raw_demand_metrics'[inquiries_count] ),DATESINPERIOD ( 'date_dim'[Date].[Date], LASTDATE ( 'date_dim'[Date].[Date] ), -7, DAY ))&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;ccowen&nbsp;,
&nbsp;
Sorry, not very clear. But if you want to choose&nbsp;continuous axis, please refer to
Customize X-axis and Y-axis properties - Power BI | Microsoft Learn
&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

ccowen · Answer

Hi, I am not able to select continious axis. It is not an option.

I have a DAX formula, a date on the x-axis, (Month and Day), Year in the legand. I want to dsplay the result of the formula YoY, so the x-axis diplays results from Jan1-Dec 31, for multiple years (legend 2020, 2021, 2022 etc). I created this but since the x-axis is categorical, the chart is very wide, has a scrollbar. I want it to fit and cannot get it to. Does that clear up the issue?

Forum Discussion

DAX formula and using on line chart with continuous date axis

2 Replies

Related content

If formula

Group By not continuously applying

DAX Formula Help

formula

Continuous Formula