cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sudhavi_84
Resolver I
Resolver I

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?

 

 

 

 

2 ACCEPTED SOLUTIONS

@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

videesh_0-1621608899861.png

 

 

I created this below table using mesaures

videesh_2-1621609008373.png

 

 

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?

 

 

View solution in original post

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

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

7 REPLIES 7
Sudhavi_84
Resolver I
Resolver I

Thank you @Greg_Deckler 

Greg_Deckler
Super User IV
Super User IV

@Sudhavi_84 You cannot use a measure in an Axis.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@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

videesh_0-1621608899861.png

 

 

I created this below table using mesaures

videesh_2-1621609008373.png

 

 

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?

 

 

View solution in original post

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

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

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

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Not really but that was the requirement:-)

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors