Log In
Register
Home
Controlling Data Shown in Graph When Data Source is Named Range
Shelley Perritt
Member
Members
Power Query
Power Pivot
Power BI
Power Query
Power Pivot
Power BI
Forum Posts: 13
Member Since:
April 18, 2015
April 18, 2015
Offline1
September 27, 2017 - 4:10 am
Hello
I have a dashboard that has some graphs showing data monthly and others showing quarterly. They are all using the same "raw data" sheet. For the quarterly, I want to avoid showing Q2, for example, until all 3 months of Q2 are there. Each chart has their own "period" named range.
I tried to control with a field that indicated if month is July, then offset is x and use that value for the offset formula of data i.e.
=Offset(IP_Cases!$K$3,0,0,CountA(IP_Cases!$K:$K)-x,1)
but I couldn't get that to work. Any suggestions welcome, thanks.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Misael Gutierrez Sr., Bright Asamoah
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
David du Toit
Forum Stats:
Groups: 3
Forums: 24
Topics: 6358
Posts: 27805
Member Stats:
Guest Posters: 49
Members: 32335
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —