So in summary, I wrote a Switch measure that will morph into different measures when filtered, and then used a disconnected table to pass a filter to that measure. And then I remembered another trick I learnt from Rob Collie using disconnected tables to feed a measure – I new I had a solution. Switch statements can be used to create a Switch Measure ( like the ones I used in this blog post here back in 2014) and I figured this could be part of the solution. When I was thinking through this problem, my first intuition was to use a Switch statement somehow. As you can see below, it is possible to flip values between columns on rows from the Pivot Table Fields List.
This limitation does not exist in an Excel Pivot Table. You can then take any column of data from your data model (typically from a Dimension/Lookup table) and place that on rows in the Matrix. The only way that you can use the Power BI Matrix visualisation (at this writing) is to place the measures on the columns as shown below. Measures Can Only be Placed on Columnsįirst the problem.
But I came up with a trick that makes it possible, so read on to find out how. You may or may not be aware that it (previously was) not possible to put Measures on rows in a Matrix in Power BI. You can now do this natively in a Matrix, but this is still a good trick that can be used to solve various problems.
0 kommentar(er)
