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.
Hello, my issue is not resolved, so I do not feel comfortable accepting a solution. I attempted to create a disconnected table and use it in the slicer but it did not yield the desired results. I've provided sample data in the original post so if someone could reproduce the suggested solution I'd be very grateful, but as of now there is no resolution.
Hi pbi_dot_edu
I have attached a few screenshots and the .pbix file demonstrating this logic. Please review them to see if this solution aligns with your requirements.
When no city selected it should display all the range of the total dataset is $45-$8000.
When Austin is selected, it should display the range of the total dataset is between $45-$75.
When Sacramento is selected, it should display the range of the total dataset is between $3000-$8000.
I hope this the required solution you are expecting.
If this response is helpful, please mark it as an Accepted Solution to benefit other community members.
Thank You!