Forum Discussion
What-If Parameter with Dynamic Range
Hello, I wanted to let everyone know I found a solution to this problem by following the steps outlined in this post:
https://www.sqlbi.com/articles/how-to-enable-the-single-value-option-in-a-power-bi-slicer/
If one has used Tabular Editor, which I have, the solution is incredibly simple. All you have to do is edit an extended property on the numeric column you wish to use. Any numeric column can be used in a single-value slicer, and it will be responsive to filters as any other field would.
For my solution, I had to add a few steps to (create multiplier values, crossjoin) to get a range of values. A bit of extra work, but the solution fits my needs perfectly.
Hopefully this will help someone.
Hi v-karpurapud ,
Apologies for the late reply; we had moved on to another project and I have just now been able to return to this to test the solution.
Unfortunately, this does not work for me, as the output is a range slider. I need the output to be a single value, as this value is an input in another calculation. When the calculation receives a range, it does not work.
I appreciate your help with this, and will continue to search for a solution.
Hi pbi_dot_edu
Thank you for the update, and no worries at all regarding the delay.
Considering that your calculation requires a single value input and the current approach results in a range slider, it appears the requirement is more specific than what standard configuration options support. Since this involves behavior that may depend on internal Power BI logic or limitations, I recommend reaching out to Microsoft Support for a deeper investigation.
You can submit a ticket through the Microsoft Power BI Support Portal:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank You!
Hi pbi_dot_edu
We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.
Thank you for your understanding and participation.
Hi v-karpurapud , it has not been resolved yet.
Hi pbi_dot_edu
I wanted to check if you have raised a support ticket with Microsoft. If so, please be patient while Microsoft addresses and resolves your issue.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.