Page 1 of 1

Formatting line colors in PowerView

Posted: Sun Sep 13, 2015 8:12 pm
by SeanAchim
Ok, so after solving my own problem so quickly (see 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 part and parcel of the same topic anyway - so...

What's with the fact that there is now way to format the colors of my graph the way I want to? There doesn't seem to be anyone on the internet talking about this. Just try and google for [format excel powerview graph line colors] and see how vacant that space is.

In one of the forums someone actually says that PowerView is intended to keep it simple! So you are left with accepting anything that the current themes gives you - so...

Has anyone been able to cheat the system and get out what their client has asked for? My client is pedantic and demands his own color scheme based on their corporate colors - and I agree with him, so... Has anyone been able to get the better of this?

Re: Formatting line colors in PowerView

Posted: Mon Sep 14, 2015 2:07 pm
by MattAllington
This is one of the biggest issues I see with Power View (there are many more). To the best of my knowledge there is no work around. Power BI Desktop has just allowed you to change chart colours as of the last release. There is still no way to do it in Power View, which is why I hardly ever use it.

Re: Formatting line colors in PowerView

Posted: Tue Sep 15, 2015 2:07 am
by SeanAchim
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 much right and so much more wrong. I've just installed the new Power BI Tool and am planning to get into it, what is you take on it so far?

Re: Formatting line colors in PowerView

Posted: Tue Sep 15, 2015 5:44 am
by MattAllington
Unfortunately my view on is similar to Power View. I desperately want it to work, and I am trying to see how I can make it work for me, but so far I have not been able to get the tool to work the ways I want it to work. Maybe it can do things and I just can't work it out. But if that is the case, then the stated goal of "ease of use" is failing.

The big limitations for me are that it doesn't have an equivalent of a Pivot Table. I do almost all of my work in pivot tables, and to not have this just stops me dead in my tracks. Also it is not possible (to my knowledge) to put multiple objects on a canvas unless they are all interlinked and cross filter. But what if I don't want that?

I want to find time to make it work, but each time I start I simply give up due to lack of progress towards what I need. I accept this could be a knowledge gap with me, but like I said, it doesn't seem to be intuitive to me - not to get the visualisations I want.

I would love to hear from anyone who is getting value from it, and possibly share some of their visualisations.