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.
Hi kel thanks for the help, the report is extracted from a bigger model from SQL Database table
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