Forum Discussion
Create summarize table with if statement
Hello everyone, I'm creating a scorecard with two main features. The first is a table with overall KPIs. This has been straight forward to create. What I would like to do is populate a table with...
HI Anonymous ,
>>However I get a multiple column error.
Unfortunately, power bi not support this.
AFAIK, if statement not support to return table or multiple columns as expressions result. In addition, Power bi not support to create dynamic calculated column/table based on filter/slicer.
Regards,
Xiaoxin Sheng
Good to know. The best work around I can think of is to use the button-bookmark approach where I stack a bunch of detailed tables on top of each other and only display the one based on the button they select.
Not as elegant of a solution than what I wanted but it's the best I can do.
Did you end up coming up with a solution? I am facing this right now.