DAX formula and using on line chart with continuous date axis

[ccowen]

Hi,

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?

Measure 2 =
CALCULATE (
sum ( 'nrtp.raw_demand_metrics'[inquiries_count] ),
DATESINPERIOD ( 'date_dim'[Date].[Date], LASTDATE ( 'date_dim'[Date].[Date] ), -7, DAY )
)

 

[ccowen]

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?

[Anonymous]

Hi @ccowen ,

Sorry, not very clear. But if you want to choose continuous axis, please refer to

Customize X-axis and Y-axis properties - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.