Forum Discussion
Creating a table with measures as rows
Hello I would like to create a Page that looked like this:
How do I create this table?
Can I dislplay an entire table if I create this:
Desired table =
SUMMARIZE(
([Factory Name], "Value", "Rank")
("Name of Measure 1", [Measure 1], [Rank of measure 1]),
("Name of Measure 2", [Measure 2], [Rank of measure 2]),
.
.
.
("Name of Measure N", [Measure N], [Rank of measure N])
)
Thank you for any tips you have!
2 Replies
Hi Anonymous ,
you can create an unrelated table in which you create a row for each measure label. Then you create a measure that uses SELECTEDVALUE and SWITCH statements to perform the appropriate calculation for each measure label and return the result.
This blogpost describes the same procedure with a different use case.
https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027There's a workaround to achieve this with a disconnected table
http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
In power bi, you can't put the measur directly into the row field.
There's a Idea about it:
