Sometimes you want a feature in Power BI that doesn’t seem to exist. Luckily, Power BI is full of hidden ‘features’ that allow you to do what you seemingly could not do.
Same with workouts. Convention would have you on your back to do some good old fashioned crunches, straining your neck along the way. But hey, why not do these standing up? Sure you can’t lift both legs off the ground at the same time, but you can still get results another way.
With Power BI, the trick seems to be start with the way you can do it, and then switch over to the method you would like to ‘carry over’ the features that are available in one functionality to the other. An example –
Default: Advanced Filter – only 2 conditions
Workaround: Using Basic Filter – select the number of options to equal the number of advanced conditions needed. Then switch to Advanced filter, et voila!
There are some other examples that are in the back of my head… will try to post them as they surface back to top of mind.
