Dax Measure

[Sudhavi_84]

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 · Accepted solution]

@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?

[Sudhavi_84]

Thank you @Greg_Deckler 

[Greg_Deckler]

@Sudhavi_84 You cannot use a measure in an Axis.

[Sudhavi_84 · Accepted solution]

@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 · Accepted solution]

@Sudhavi_84 Well, you could create a column like this perhaps:

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

[Sudhavi_84]

Thanls @Greg_Deckler , I will try this and will let you know.

[PaulDBrown]

@Sudhavi_84 
Is there a particular reason you want to use the minimum date showing the total value for each project?

[Sudhavi_84]

Not really but that was the requirement:-)