In PowerBi, I'd like to filter/scale a selection of data , but leave the rest of the data unchanged. How can I do that?

I have a sliding scale that allows me to change the scale from 2-5. If I change the scale to 2, all the data is multiplied by 2. Is there a way to isolate one color and only apply the scale to that, and leave the rest the same?
Color Scale Raw Volume Scaled Volume
Yellow. 3. 100 300
Blue. 2. 25. 50

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

Calculate(sum(raw volume), filter(tablename, colorcolumn=“yellow” * scale value))

Scale value is the selected value (what if) measure. Only yellow is displayed and the sliding scale doesn’t work anymore…

like

Use the "What If" analysis feature and use the slicer's value in a measure that uses CALCULATE and FILTER or an IF conditional that either just retrieves the value or calculates the modified value.

Related Posts

Does anyone do contract EA work with Double? If so, what are the pros/cons? TY.

like

What's your Myers-Briggs type? I'll start: ENTP. I'm guessing there are quite a few other others on here that are ENTP as well.

like

Do you have any advice on study materials for a fixed income analyst role? My partner is trying to switch to banking and I would really appreciate any advice

like

I have an offer from IBM with band 7A. Could you please tell me how much hike i would get after 2 years if i join IBM, as i have an offer from TCS too and they are giving more than IBM. Also please mention the benefits which i will get.
YOE- 5.5 years
Domain - SAP SD

like

Hi Sharks,

Which one to Choose???
NTT Data 8.3 Fixed
Transunion 8 Fixed
Techstack: QA Automation Exp: 2.5 years

like

Intense meeting: Senior manager - I have never worked in a project like this where we roll over the team leads’ plans and force them to accommodate like this! More senior manager: - Well you have never worked with me before

funnylike

Looking for a Legal Recruiter or Recruiting Firm. Young Associate with Healthcare/Health Law Experience.

like

Client has a VA w Principal in an IRA Rollover account w high expenses and no other benefits. My B/D has a selling agreement w them, can I get listed as the servicing agent until it can be moved?

like

How do you guys manage relationships when working long hours and also on weekends?

like

Does anyone have a good term paper topic for seniors? It needs to be persuasive/argumentative in nature.

likehelpful

I get 2-3 offers a week on one of my rental properties. People just call up begging for me to sell 🤦🏼‍♂️ in Austin. Happening to you guys too ?

like

Got an offer from Microsoft for a tech lead position. Considering the San Francisco office as opposed to relocating to Seattle. How big is the SF office, are there technology groups that sit in that office? Would it be too hard to network and connect if most of the groups sit in Seattle?

Hello Fishes, I am a Servicenow developer with 3+ years of experience.
Currently having offer from wipro of 13.5 Lpa is it worth joining ?

How is career growth, job security and work/life balance in wipro?

Thanks

like

Hi, I am wondering what is Azure VM support Engineer at Microsoft ? Is it mostly customer service? I got the job offer through stuffing company. I prefer doing more backend than customer facing all day

like

Microsoft Does the person who refers matter, in Microsoft? Their level or area of work. Does a referral from someone in similar line of work get more weightage?

like

Anyone from Cummins Pune or HR team. Please comment.

like

11 like pls

like

Has any Canadian citizen living in the US, returned to Canada for less than 14 days? Did the 14day quarantine apply and any way around it?

like

What is the salary range of a Manager at KPMG Global Services (KGS) with 7.5 years experience and an MBA?

KPMG KGS KPMG India

like

Additional Posts in Data & Analytics Consultants

BCG Gamma folks,

Are you happy with the work you are doing or getting?
Or are you planning to move?

like

Any recommendations on lucrative ($$) exit opportunities for Data Governance / Data Strategy Consultants? Either in the field or not. Where is the pot of gold for someone with my profile? (Currently a Manager - not technical at all.)

like

Best way to pass az 304 exam in a week?

like

Has anyone given the CAP (Certified analytics professional) exam here?

like

Has anyone completed a Springboard career track? If so, what are your thoughts?

like

Any tips on how to figure out what approaches are widely used in specific use cases in the industry? It's quite easy to keep up with the latest in academia but most of the time it's not what's proven and being used in a business context. Thanks!

like

At what level in BCG Gamma can you get to 300k+ TC?

like

2 YOE at current company. They bumped my salary up 3600 to 75k with a recent promotion. Am I being shafted? I felt I was underpaid before, but now I really suspect so. Would appreciate if someone could help confirm or deny my suspicion.

like

How are the technical case interviews for BCG Gamma? Apart from regular business case prep, what would be some good sources to practice ML based cases from? And what would be an average salary range with 4-5 years of experience in Analytics, tier 1 city?

like

Slalom 🐠, can someone provide insight on how the in person interview is for a Data Analytics consultant?

like

Let's say I'm a former analytics specialist who left the field several yrs ago for a top 10 MBA and strategy consulting at big 4. How would I parlay this into finding *non-tech* AI/ML/DS roles like strategy or product?

I don't want to use R/SAS/etc daily again, but many places either want me to be a DS/engineer which doesn't suit my interest, or require more recent technical management experience, which I don't have.

likehelpful

When someone comments “not technical enough” even with the right masters and right languages, what do you reckon they are referring to? Hit me with all your thoughts and guesses. No right or wrong.

like

Could the fishes here please suggest some good resources to understand data pipeline designs and best practices for the same?

like

Can someone from Deloitte USDC share their salary for the Data Analytics Solutions Consultant role, along with their city/state?

like

Any recommendations for ramping up my SQL skills (for free ideally but willing to pay for a course if worth it). No experience but looking to strengthen my analytics skillset

Is anyone in the DS/ML consulting world? Specifically for private sector clients. I’m wondering how it’s different from government related projects.

like

How is BCG gamma for career growth? Do people get to partner level from the group? Also what kind of projects do you usually get involved in?

like

Anyone who has used python for data science or python with SQL - what tools and libraries do you like? Do you have any course or reading recommendations for someone just starting out?

like

Reading through some possible interview questions for FAANG. One of the ones I've seen on Glassdoor are to design a basic architecture structure for something like Netflix or Twitter or Spotify. I've been researching online using AWS or GCP (still learning all the moving parts of architecture). Any advice on how the setup would be? I'm assuming you'd start with some Load Balancers. For Netflix maybe have different different APIs for signing up vs scrolling through possible movies?

like

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

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