Using the superstore dataset, supposing we have a certain order quantity target we want to evaluate on all states and give dynamic feedback based on how well we met that target. But this time, we want to do it in Power BI.
Start with same base structure:
Then create parameter under Modeling tab.
It will create a new table and corresponding parameter.
Then we can create a measure similar to tableau calculation.
Because power bi does not have if-elseif-else function, we need to tweak the query a little bit, it can be some thing like this.
Sales Performance = IF (
sum(Orders[Quantity])> 'Quantity Parameter'[Quantity Parameter Value],
"We did good here!",
IF (
sum(Orders[Quantity])= 'Quantity Parameter'[Quantity Parameter Value],
"Not bad but we can do better",
"Need to sell more!"
)
)
update the parameter slicer and you can see how well we performed!