New to Power BI - problems turning off aggregation for date fields.

Bar charts are meant to compare a (counting) value of two or more things.  It's a column chart turned on its side.

Sounds like you need something like a Gantt chart.  Look in the AppSource for Gantt chart and try one of the ones from there. I think those will be more in line with what you're trying to do.

Hope this helps

David

Hi zimanche ,

According to your description, it seems that you want to set Date as X-axis, right?

I’m sorry to tell you that your requirement might not be achieved currently . As dedelman_clng  said ,maybe you could use Gantt visual instead.

Firstly for Gantt visual, use the following formula to add a duration column:

durition =
DATEDIFF ( 'Table'[date], NOW (), DAY )

My data sample and  the visual looks like this:

Is the result what you want? If not, please upload some data samples and expected output.

Please do mask sensitive data before uploading.

Best Regards,

Eyelyn Qin