Forum Discussion
Problem with Switch and Selected Value Function
Hi guys, I had trouble building this Visualization. Whenever I put it inside a Switch function, it always returns Null. I think it has something to do with the Row Filter context. Like in the pictu...
You have 2 possiblities. Talk to the people who are doing the extract and ask them to provide you with an un-pivoted set of data, or use power query inside power bi to unpivot the data before you start analyzing it.
You have 2 possiblities. Talk to the people who are doing the extract and ask them to provide you with an un-pivoted set of data, or use power query inside power bi to unpivot the data before you start analyzing it.
just to make things cliear, here is the dummy table i built to represent the un-povited data
| Statement | Account | Result | Order |
| L1 | 14. Profit before tax | 67 | 1 |
| L1 | 15. CIT | 8 | 2 |
| L1 | 16. Deferred tax | 89 | 3 |
| L1 | 17. Profit after tax | 55 | 4 |
| L1 | 17. Profit after tax | 44 | 4 |
| L2 | 14. Profit before tax | 9 | 1 |
| L2 | 15. CIT | 344 | 2 |
| L2 | 16. Deferred tax | 6 | 3 |
| L2 | 17. Profit after tax | 44 | 4 |
| L2 | % Profit | 666 | 5 |