Forum Discussion
Use Measure as Axis in visual
I solved the issue. I created a new table with the axis lables in the first column, then used If statements to look at the value in the first column. If it was one of the subtotals, it returned the measure I created. If it was an actual status, I used:
CALCULATE(counta('Idea Factory One Utility'[Status Of Idea]),
FILTER(all('Idea Factory One Utility'), 'Idea Factory One Utility'[Status Of Idea]=Idea_Status[Status Type]))
That gets me part of the way there. I need to also include a "subtotal" as a vlaue on the axis. Here is the original graph that I'm trying to recreate
.
The grey bars are sub totals of the actual statuses. It was created in excel using three series. The Grey bar is one, the orange is another, and the "clear" bar is the third. In the series for the grey bars, the value for the orange and clear is zero, making it appear they are not there. This can be acomplished because I can manually indicate the values for the axis and then assign data to the three series.
I've got all the values I need, I created them using measures, but I can't figure out how to get that measure to align with an axis label. Is there a way to create a new table with the axis labels in a column, and then refernce the measures in the next column?
Any help is appreciated.
I solved the issue. I created a new table with the axis lables in the first column, then used If statements to look at the value in the first column. If it was one of the subtotals, it returned the measure I created. If it was an actual status, I used:
CALCULATE(counta('Idea Factory One Utility'[Status Of Idea]),
FILTER(all('Idea Factory One Utility'), 'Idea Factory One Utility'[Status Of Idea]=Idea_Status[Status Type]))