Dax Measure

I have a list of Projects( Comes from Table), Date (Created Measure), Total Value(Created Measure).

I am trying to make this Table in to Clustered Column Visual, but for some reason, Date Measure is not coming to Axis Category.

I want Dates on Horizontal(X Axis) and Projects on Vertical (Y Axis) and Total in Values.

But for some reason Date measure is not allowing me to move in to X Axis. Please may I know how can I acheive this?

Sudhavi_84
5 years ago
Greg_Deckler , Thank you for the response.

How can I achieve this one. do we have any other way to fix this?

All I have is list of projects which are having different dates with different values in Current year. I need to sum all the values. I have to sum it and show with the Minimum date in the Clustered column visual.

For example

I have this Table

I created this below table using mesaures

My aim is to provide Clustred column chart
Dates in X axis and Values in Y Axis and Projects in Column.

Please any help, any other way to acheive this?
Greg_Deckler
5 years ago
Sudhavi_84 Well, you could create a column like this perhaps:

Earliest Date Column = MINX(FILTER('Table',[Project]=EARLIER('Table'[Project])),[Date])

Forum Discussion