Forum Discussion

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
1 year ago
Solved

Line chart does not plot data between some points

I have a line chart visual that contains data for each month from 2024 to current, and it plots the lines perfectly.  However, when I apply a filter to show certain months, it only partially applies ...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hello PowerBINoob24,
    Thanks for your followup.

    The Type (Continuous / Categorical) option in the X-axis settings will only appear if the field on the X-axis is a date or numeric data type.

    From your screenshot, it looks like the X-axis might be using a text field (for example, “Month Name”). In this case, the Type option won’t be available.

    To enable the setting:

    • Ensure the field on the X-axis is an actual Date column.
    • In Model view, check the Data type if it’s Text, change it to Date.
    • Replace the current X-axis field in your visual with this Date field.
    • Now, in the X-axis formatting pane, you should see the Type dropdown and be able to switch between Continuous and Categorical.

     

    Best Regards,
    Ganesh singamshetty.

PowerBINoob24's avatar
PowerBINoob24
Icon for Resolver I rankResolver I
1 year ago

This is all I get under the X-axis format.  No option for type.

 

v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hello PowerBINoob24,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I have reproduced your scenario in Power BI Desktop and confirmed the behavior you described when the X-axis field is set as a date and the Type option is available.

By switching the X-axis → Type from Continuous to Categorical, the line chart now connects all available months even after filtering out non-contiguous months, which matches your expected output.

For your reference, I’m attaching the .pbix file.

 


Best Regards,
Ganesh singamshetty.

  • PowerBINoob24's avatar
    PowerBINoob24
    Icon for Resolver I rankResolver I
    1 year ago

    As noted in my screenshot above, I cannot find the setting to change to categorical.  It's not there.

    • v-ssriganesh's avatar
      v-ssriganesh
      Icon for Community Support rankCommunity Support
      1 year ago

      Hello PowerBINoob24,
      Thanks for your followup.

      The Type (Continuous / Categorical) option in the X-axis settings will only appear if the field on the X-axis is a date or numeric data type.

      From your screenshot, it looks like the X-axis might be using a text field (for example, “Month Name”). In this case, the Type option won’t be available.

      To enable the setting:

      • Ensure the field on the X-axis is an actual Date column.
      • In Model view, check the Data type if it’s Text, change it to Date.
      • Replace the current X-axis field in your visual with this Date field.
      • Now, in the X-axis formatting pane, you should see the Type dropdown and be able to switch between Continuous and Categorical.

       

      Best Regards,
      Ganesh singamshetty.