Has anyone developed a dynamic dashboard where users can select multiple criteria from dropdowns (not just one), and the underlying data, charts, and even conditional formatting update in real time without relying on VBA?

Curious about the most effective approaches—Power Query tricks? Data Model magic? Slicers with multi-select.

like
Posting as :
works at
You are currently posting as works at

Some people will do anything not to use powerbi lol

Related Posts

Can you typically negotiate post MBA consulting offers?

likehelpful

What are the current vibes at Chiat Day?

like

Anyone from Capability Network - T&O?

like

Hi Fishes, need your help.
Can anyone tell me the exact role for Quality analysis in Accenture. Thanks in advance.

Hi all,
Recently gone through ICICI bank debt manager DSMG interview, HR told will provide non industry matching hike because my last switch was just 6 months ago. What should be the expected CTC? Currently working as collection manager at HDB financial services Ltd, CTC-5.1, Work exp-4.9Y.

What makes a great investment teaser vs an average one?

like

What are some good practices during the sales phase of a potential project to execute before the contract is signed? Seems obvious but would love some ideas on standard operating procedures that help with seamlessly handing over a signed contract to the account team. For example, speaking to the potential client explicitly about their role in staying on schedule, reviewing scope creep consequences, etc.

like

Could someone take a look at my about me section for my LinkedIn pls. Would appreciate some feedback. Trying to transition from reception job to selenium or lean six sigma. Please dm me!

like

Any insights on PwC Deals Analytics roles?

like

Got promoted to Senior Associate but imposter syndrome is kicking in. Any advice for gaining the competency to perform at the level required?

like

Any KPMG FDD associates willing to chat?

like

Quarantine Starter Pack insta @chicksonwallstreet

Post Photo
like

Can we start a thread for all the acronyms? Y’all lose me with all the lingo 😂

funnylike

What is the standard billing for a surgical PA? 20% of what the MD is billing? Does anyone know?

like

Does anyone work for Biogen or BMS I have a free questions on a couple of positions I'm interested in.

How is performance measured at MBB?

like

How to move into executive leadership? I’m a mid-40s former MBBer with, I think, an impressive and diverse resume. I think I’m suitable for an executive leadership role, but unsure about how to pursue one. Any suggestions? Career coach? Headhunters? Cold “calls”? Thanks!

like
like

Can anyone explain why insurance defence work in the US is such a terrible place to be? I work in insurance defence / coverage (financial lines) based in London and it doesn’t seem like it has as negative of a reputation as it does in the US, why is that? 👀

like

What is the post MBA sr consultant $ for MBB Canada?

like

Additional Posts in Excel Genius

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

How do you fix microsoft excel cannot paste data error?

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

What are your top Excel ninja tricks? Ones that few people know...

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal