Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Multiple slicers make graph go blank

I am attempting to make a dynamic line graph to visual labor demand vs a static labor capacity line for my company. There is a table for each product line at our facility with three production volume scenarios. I have created a measure for each product line to switch between each of these scenarios. 

 

DM Hours =
VAR DM = SELECTEDVALUE(Scenario[DM Scenario])
Return
Switch(true(),
DM="PP",SUM('DM'[PP Hours]),
DM="S1",SUM('DM'[S1 Hours]),
DM="S2",SUM('DM'[S2 Hours]))
 
There are six product lines in total. I have created a scenario column for each of them for the three possible scenarios "PP", "S1", and "S2". My intention was to have a slicer that would be able to change the values for a product line in each scenario.
cammarcz_0-1619096725891.png

There would be seven lines in the graph. One for each product line, and then a total. I created another measure to sum each of product line measures.(see the measure above). The problem I'm having is, if all of the slicers are not set to the same selection, the graph goes blank. I have turned off the interaction between the slicers, but this did not help. Any advice would be greatly appreciated. 

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi  @Anonymous ,

 

Is your issue solved now?If not,could you pls check my last reply?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

First picture with matching slicer selections. Second picture with non-matching slicer selections. Each slicer is using a different column, so it not as if I am trying to select two scenarios from the same column at once.

cammarcz_0-1619097311343.png

cammarcz_1-1619097397063.png

 

Hi  @Anonymous ,

 

It means that the selections conflict.Could you pls provide some sample data with expected output for test?

 

Remember to remove the confidential information.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.