Month to month on a line graph

[Jilly72]

Hi there 

quite new to PowerBi I am trying to visual the subscription uptake month by month I.e jan 2025 has 61% yes subscribe and Feb has 55% subscribe I have put a calendar table in and a table with the dates and month but nothing when it comes to getting the line graph when I select to show Jan and Feb at the bottom. Any help would be amazing.

thank you so much 

[v-veshwara-msft]

Hi @Jilly72 ,

Following up to see if your query has been resolved. If any of the responses helped, please consider marking the relevant reply as the 'Accepted Solution' to assist others with similar questions.

If you're still facing issues, feel free to reach out.

Thank you.

[v-veshwara-msft]

Hi @Jilly72 ,
Thanks for using Fabric Community to post your question.
We wanted to check if your query has been resolved and if any response was helpful. If yes, please consider marking it as "Accepted Solution" to assist others with similar queries. If further assistance is needed, please reach out with some additional sample data without any confidential information.
Thank you.

[danextian]

Hi @Jilly72 

Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to an Excel file or a pbix stored in the cloud. Note: Sample data doesn't have to be confidential but it must represent your actual use case.

[johnbasha33]

It sounds like you're trying to create a line graph to show the percentage of users who subscribed each month. Here’s how you can set it up:

Step 1: Ensure Your Data is Structured Properly

You need at least two tables:

1. Fact Table (e.g., Subscription Data)

   • SubscriptionDate (date when the user subscribed)
   • UserID (unique identifier for subscribers)
   • Subscribed (Yes/No or 1/0)

   • Calendar Table (if you haven’t already)

     • Date (all dates from your dataset range)
     • Year-Month (formatted as "Jan 2025", "Feb 2025")
     • Month (numeric, for sorting)
     • Year

       👉 Make sure your Subscription Data is linked to the Calendar Table via SubscriptionDate.

       Step 2: Create the DAX Measure for Subscription Rate

       Use this DAX measure to calculate the monthly subscription percentage:

       DAX

       CopyEdit

       Subscription Rate = VAR TotalSubscribers = CALCULATE(COUNT('Subscription Data'[UserID]), 'Subscription Data'[Subscribed] = "Yes") VAR TotalUsers = COUNT('Subscription Data'[UserID]) RETURN IF(TotalUsers = 0, BLANK(), DIVIDE(TotalSubscribers, TotalUsers, 0))

       💡 This measure counts the number of users who subscribed each month and divides it by the total number of users.

       Step 3: Create the Line Chart

       1. Add a Line Chart visual.
       2. X-Axis: Use Calendar[Year-Month] (formatted like “Jan 2025”).
       3. Y-Axis: Add the Subscription Rate measure.
       4. Ensure Calendar[Year-Month] is sorted correctly (by Calendar[Month] and Calendar[Year]).

          Step 4: Troubleshooting

          • If the chart doesn’t show data, check if the Calendar table is properly related to your data.
          • If months appear out of order, sort Year-Month by Month.
          • If nothing appears, test the measure in a table visual first.
            
            Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

@Jilly72