Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
1 year ago
Solved

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

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
 
 
 
Need Help
Show and Tell
Tips and Tricks
  • kushanNa's avatar
    kushanNa
    1 year ago

    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.

     

     

4 Replies

  • kushanNa's avatar
    kushanNa
    Super User
    1 year ago

    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.

     

     

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    1 year ago

    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.

  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    1 year ago

    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's avatar
    v-karpurapud
    Community Support
    1 year ago

    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.