Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Sudhavi_84
Helper V
Helper V

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
Sudhavi_84
Helper V
Helper V

Thank you @Greg_Deckler 

Greg_Deckler
Super User
Super User

@Sudhavi_84 You cannot use a measure in an Axis.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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

 

 

@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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.