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

[zimanche]

I am trying to display dynamics 365 opportunity names and submission dates with a status legend on a horizontal bar chart. I'm just trying to display the names on y-axis and the actual date values on the x-axis but for some reasone it only lets me display count of dates not the actual dates. I thought this would have been a very simple requirement just to attaching each fields to the corresponding axises 🙄 I don't know If there's a turn off aggregation setting some where. I'm pulling the data thru a web api call and transformed it to a table with just a few colums I needed from the JSON response.

From what I read online so far, I made sure the date fields are of date/time data type, turned summerization off for both fields but still no success. Any help or direction is much appreciated!

Thanks

[dedelman_clng · Accepted solution]

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

[Anonymous · Accepted solution]

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

[zimanche]

Thanks for the reply Eyelyn, I was hoping there would have been something out of the box for senarios like this in power BI and not have to add an external visual to achieve something like this with just one of the bar or line charts 😏

[fhill]

You may also want to post a small sample of data, and mock up what you are trying to achive.  Hope we can help.

Forrest

[dedelman_clng · Accepted solution]

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