Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
I have a column called duration. I want to create a dynamic what if parameter that a user can change.
Duration column
5’
10’
20
8’
….
If the parameter is set to 10’ and up then its “greater than parameter” or “less than parameter”
i.e.
5 less
10 less
20 greater
8 less
I created a parameter like this:
Then I create a new column:
With my function lookling like this:
lower_or_greater = IF(Parameter[Parameter Value] < 'individual lines csv'[Duration],"Smaller Parameter" , "Greater Parameter")
So this gets me the values Smaller/Greater Parameter like this:
But the problem that im currently having is that, even when I change the slider, it still is defaulted to the 500 default that I had set earlier:
Even with the slider that i put on there, it will not change the location"
Can someone tell me what im doing incorrectly perhaps.
my columns look like this:
Solved! Go to Solution.
Hi @Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
Create a measure as below to replace your original calculated column [lower_or_greater]:
Best Regards
Hi @Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
Create a measure as below to replace your original calculated column [lower_or_greater]:
Best Regards
@Anonymous Columns are not dynamic based on user input, they are calculated once when created and only recalculated during data refresh.
okay. So to have that feature, i made it into a measure with this:
Now that I have that new measure, i want to bucket the 1's and 0's into a 100% stacked column chart. What can i do after doing this?
or do you see what im trying to accomplish and do you have any other alternatives to what im trying to do ?
@Anonymous In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
does that work for what if parameters. and what did you mean by data refresh by any chance ?