Forum Discussion

SDVN's avatar
SDVN
Icon for Helper I rankHelper I
1 year ago
Solved

Using measure for axis in a column graph

I want to show the current status or stage in which the project is in. If there is "stage 4" completed in the table that means the project is in stage 4, completing stage 1,2 and 3 (thought the statu...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    1 year ago

    Hi SDVN ,

     

    No problem just change the measure to get the order value instead of the Stage value something similar to this:

     

    Project by Status Withou Relationship = VAR _Stage = MAX('Table'[Order])
		VAR _temptable = CALCULATETABLE(
			SUMMARIZE(
				'Projects (2)',
                'Projects (2)'[Projects],
				"Status", MAX('Projects (2)'[Order])
			),
			CROSSFILTER(
				'Projects (2)'[Order],
				'Table'[Order],
				None
			)
		)
		RETURN
			COUNTROWS(FILTER(
				_temptable,
				[Status] = _Stage
			))

     

    Has you can see the result does not change:

     

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi SDVN,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.