Direct Query

[usman96]

Can We make What IF parameter in Direct Query Mode?

[miltenburger]

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

[usman96]

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

[v-yuezhe-msft · Accepted solution]

@usman96,

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


Regards,
Lydia

[Anonymous]

@v-yuezhe-msft 

Is it still not possible ?