Forum Discussion
How can i put values in front of Rows using matrix?
- 5 years ago
Hi, Anonymous
According to my test, the only way to achieve the Matrix output like this is to change your data source, you can try to change your data table like this:
Then create another matrix and place it like this:
And this can roughly achieve what you want.
You can download my test pbix file below
If this result is not what you want, you can go to the Power BI Idea to submit a new idea so that people with the same idea can vote for you. I will also vote for you.
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
Please correct me if I wrongly understand your question.
I want to suggest using Table Visualization, and create a measure for each year.
In this case, generally, you can change the order of the year columns and Place column.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
No, i wanna change the position of the values. If u use a matrix you first need to give Rows and after that values. I am using Matrix as a visual, and i wanna put the value 2012 and 2013 in front of my row value what is place. Just changing the position of my data in a matrix
- MFelix5 years agoSuper User
Hi Anonymous ,
This depends on the way you data is setup.
Are the years separate columns on your data or a single column and the years are values in rows? Do regarding the Place I assume you want to have the first value correct?
Can you share a mockup of your data setup? Depending on the way you have the model the calculation can go from a disconnected table to the creation of different measures.