taylorrc Tracker

Re: TOTALYTD until TODAY

taylorrc — Thu, 01 Feb 2018 15:07:31 GMT

This worked great for me. Thanks!

I have a question thought. I'm also comparing to same period last year. I'm using the formula:

Last Year YTD=Calulate ([CurrentYearYTD]), SAMEPERIODLASTYEAR(DATESYTD('Table'[Date])))

This is returning the same value at the CurrentYearYTD calcluation. Any suggestions to make this comparison?

Re: Use Measure as Axis in visual

taylorrc — Wed, 01 Mar 2017 15:13:08 GMT

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]))

This retuned the values that I needed for the visualtion. Its a little brute force, but it worked.

Re: Use Measure as Axis in visual

taylorrc — Wed, 01 Mar 2017 15:12:00 GMT

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]))

Re: Use Measure as Axis in visual

taylorrc — Wed, 01 Mar 2017 14:29:26 GMT

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.

Use Measure as Axis in visual

taylorrc — Tue, 28 Feb 2017 20:54:53 GMT

I am trying to create a visual similar to this:

but I need to include some values that are sumations of some of the columns. For example, a total column that is a sum of all the values. Another is a value called "Accpeted" that is a sum of Imlplemented, Assigned to Team, Ready for Implementation, and Being Piloted.

I've created measures to generate all these numbers for me, but I cannot get the visualization to allow me to use the measure name for the axis label. Is there a way to do that, maybe through a calulated table? I'm new to Power BI and visual analytics in general. Thanks in advance for any help.