Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
usman96
Helper II
Helper II

Direct Query

‎10-31-2017 03:39 AM

Can We make What IF parameter in Direct Query Mode?

Labels:
Message 1 of 5
757 Views
0
1 ACCEPTED SOLUTION
Anonymous
Not applicable
In response to usman96

‎10-31-2017 07:56 PM

@usman96,

It is not possible to use What if parameter in Direct Query mode, in this mode, the what if parameter feature is disabled.
1.JPG

Regards,
Lydia

View solution in original post

Message 4 of 5
911 Views
0
4 REPLIES 4
miltenburger
Helper V
Helper V

‎10-31-2017 03:41 AM

I think it is better to use the CASE statement, some more information about this that might help:

https://stackoverflow.com/questions/63447/how-do-i-perform-an-if-then-in-an-sql-select

 

Kind regards

Message 2 of 5
751 Views
0
usman96
Helper II
Helper II
In response to miltenburger

‎10-31-2017 03:55 AM

but I want to make What if parameter so that i could use it in my Dashboard as a slicer/Filter

Message 3 of 5
748 Views
0
Anonymous
Not applicable
In response to usman96

‎10-31-2017 07:56 PM

@usman96,

It is not possible to use What if parameter in Direct Query mode, in this mode, the what if parameter feature is disabled.
1.JPG

Regards,
Lydia

Message 4 of 5
912 Views
0
Anonymous
Not applicable
In response to Anonymous

‎04-13-2020 08:16 AM

@Anonymous 

Is it still not possible ?

Message 5 of 5
470 Views
0

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.

View All