Forum Discussion
Use Measure as a Column
Thanks for your reply amitchandak .
Is there any alternative so that i can convert a dynamic measure to a column and the use it in a matrix chart.
I have tried to create a new table with this three vaues as High, Low and medium but it doesnt fullfil my requiement.
I need to display some thing like this, But here the row labels as High Rotatio, Low Rotation, Medium Rotation are my measures.
Thanks
In general, this is going to involve some form of the Disconnected Table Trick because you are trying to use a measure where you are not allowed to use a measure.
Beyond that, very difficult to tell without sample source data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
