Register
Log In
Unanswered
Home
July 31, 2015
Offline
Hello,
I have a Pivot Chart that I am using but I would like to change the source data if possible. My pivot table is showing 2 value fields. 1 is a sum and the other is percentage. It makes my chart too messy to show both of these. I still want to keep the data in my pivot table but I'd like my chart to only show the sum.
Is this possible? If not is there a way to hide that on my chart?
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Don't think it's possible to hide one of these totals in the Pivot Chart and keep it displayed in the Pivot Table (and otherwise I would like to learn that also here from somebody who knows how to do this!).
There is a workaround though.
Select in the Chart the column which you want to hide. Give that 'no fill' and 'no border'. You don't see it anymore after applying.
Only thing is that the axes maybe must be re-arranged because the higher values of the totals are not visable anymore but the ax still displays it.
Is this is something for you and this case?
July 31, 2015
Offline
I'm still hoping we can find an answer to the main question though. It would be useful in the future.
This work around is actually really helpful to get the desired look that I need on my chart. Thank You!!
Most Users Ever Online: 57
Currently Online:
26 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
