The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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 Well, you could create a column like this perhaps:
Earliest Date Column =
MINX(FILTER('Table',[Project]=EARLIER('Table'[Project])),[Date])
@Sudhavi_84 You cannot use a measure in an Axis.
@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 Well, you could create a column like this perhaps:
Earliest Date Column =
MINX(FILTER('Table',[Project]=EARLIER('Table'[Project])),[Date])
@Sudhavi_84
Is there a particular reason you want to use the minimum date showing the total value for each project?
Proud to be a Super User!
Paul on Linkedin.
Not really but that was the requirement:-)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
55 |
User | Count |
---|---|
253 | |
119 | |
115 | |
95 | |
70 |