Forum Discussion

Gacohen's avatar
Gacohen
Regular Visitor
5 years ago
Solved

Dynamic or Dependent What-If parameter or Numeric Range

Hi,   I have a What-If Parameter, lets call it Machines. Machines = GENERATESERIES(0, 20, 1) I need a another parameter, or a range of values that can be used in a slicer based on the selected ...
Need Help
  • Gacohen's avatar
    Gacohen
    5 years ago

    I am not sure if I have azure data explorer?
    However, I actually ended up using a different work around. I used this concept. Power BI - Filter by a Measure in a Slicer . Instead of using a second what if parameter, I mader a measure that is the same GenerateSeries, and put that into a slicer. Then put a visual filter on that slicer.


    I think this is what parry2k  was trying to suggest.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Gacohen unfortunately that is not possible, you cannot have 2nd parameter based on machine parameters. you can (i believe) you can use a visual level filter to filter your 2nd parameter.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

 

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi Gacohen 

parry2k is correct, however what you could do is create a live connection to a static numbers table stored in azure data explorer and pass in the parameter value to the query using dynamic parameters for power bi direct query.

Definitely a lot more effort but a way to do it.

The docs are below

Dynamic M query paramters for direct query 

 

Thanks,