Search found 4 matches

by SeanAchim
Tue Sep 15, 2015 2:07 am
Forum: Power View
Topic: Formatting line colors in PowerView
Replies: 3
Views: 2214

Re: Formatting line colors in PowerView

Matt, I agree. It is frustrating when you get given a tool that is supposed to make you life easier but it ends up leaving you in a worse position. Doing something as simple as pivoting data in a matrix table should not be such a pain. Trying to format a page should not be such a pain. They get so m...
by SeanAchim
Sun Sep 13, 2015 8:12 pm
Forum: Power View
Topic: Formatting line colors in PowerView
Replies: 3
Views: 2214

Formatting line colors in PowerView

Ok, so after solving my own problem so quickly (see http://powerpivotforum.com.au/viewtopic.php?f=6&t=162 ) I've moved on to making this data work. Admin - I hope you don't rap me over the knuckles for asking a PowerView question in the PowerPivot group, but I figured that they all seem to be pa...
by SeanAchim
Sun Sep 13, 2015 7:55 pm
Forum: PowerPivot/DAX
Topic: TotalYTD Not Working
Replies: 2
Views: 921

Re: TotalYTD Not Working

Okay, so after nose-bleeding hours and days of trying to make this thing work, knowing that it was going to be a simple thing, I've answered my own question. The answer is: Stop trying to make it work as a column in your data and just go to the bottom section of the screen and type in the formula th...
by SeanAchim
Sun Sep 13, 2015 7:28 pm
Forum: PowerPivot/DAX
Topic: TotalYTD Not Working
Replies: 2
Views: 921

TotalYTD Not Working

I've been struggling for 4 days now :( I need to get the Running Total of a set of values. My formula is a classic =TotalYTD(Sum([myVal]);Calendar[FullDate]) function. I've created a Calendar table in SQL Server 2012 and brought this into my data model. I've gone into the design tab and marked it as...

Go to advanced search