SPC Charts (Dev): Using Field Parameter for alternating Weekly/Monthly Units on X-Axis

[F_Reh]

Good Morning,

I have a table with these two columns: (FirstDayOfMonth column was created for grouping records by month)...

I am using a SPC Charts (Dev) and have created a Field parameter, where the Viewer can alternate the Units along the X-Axis (between Weekly and Monthly units).

prmWeekMonth = {

    ("Week (End Date)", NAMEOF('TableX'[Week (End Date)]), 0),

    ("FirstDayOfMonth", NAMEOF('TableY'[FirstDayOfMonth]), 1)

}

When I select FirstDayOfMonth (to change the X-axis Units by monthly), I get this:

 Kindly advise (N.B there is no problem when I select the weekly option which in fact produces a valid graph).

Regards

[v-karpurapud]

Hi @F_Reh ,

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud]

Hi @F_Reh 

We have not yet received a response from you regarding your query. If the previous response was helpful, please let us know. If not, feel free to provide more details so we can assist you further.

Thank you.

[v-karpurapud]

Hi @F_Reh 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @kushanNa for sharing helpful suggestions.

Could you let us know if the suggested solution resolved your issue? This information can assist other community members facing similar challenges.

Thank you.

[kushanNa · Accepted solution]

Hi @F_Reh 

This could be because your first day of the month is showing as 01/06/2025 in the last line , but it should be 01/07/2025 ?. Check the attached demo I created. Also, I noticed that if there's only one distinct date, the output appears as a dot as well.