Month X axis is showing intermediate dates instead of Month

[rkacom]

Hello 

     I had a simple bar chart which was showing trend for last 3 Month. Date Table was custom created and marked as Date table and X axis was plotted as continuous. Y axis is a simple distinct date count value. Aso the "Show data with no value" is also set. Bar chart for latest month is distorted and shows individual date and howerver if we filter to some previous month it shows the proper value. 

      Any Idea on how to fix..

[Anonymous]

Hi @rkacom ,

Sorry for that I cannot reproduce your issue. 

Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.

You can save your files in some cloud sharing platforms and share the link here.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Yuna

[amitchandak]

@rkacom , are you using date with Continous axis?

Try use a month year column from you date table

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[rkacom]

Yes I am having calendar as custom table and have marked it as date table..To repro the issue i have trim down the powerbi to single table..I need to use Continous type

Looks like there is some weired issue..