Forum Discussion
Why can't I add columns in Matrix Values
Until last week, I was able to add new columns and perform the aggregate functions on them in Matrix Visualization. Now I can't even add those in Power BI. What can be the issue here?
9 Replies
- amitchandak
Super User
Anonymous , Can share some screenshot of issue.
There is a new release, if that is auto-updated, you can check for know issues - https://community.powerbi.com/t5/Issues/idb-p/Issues
Hi Anonymous ,
Measures cannot be put in the matrix.
For now, clear the datasource and reconnect it, and then try to add columns. Power BI Desktop is also guaranteed to be the latest version.
On your Power bi Desktop Go to File -> Options and Settings -> Data Source Settings.
It will take you to the data source page there you can delete the data base source.
Click on edit permission which will open another pop up that allows you to delete the source as shown
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
My mistake. What I want to express is that measure cannot be placed in the columns of the matrix.
Have you tried putting the columns into the matrix in other reports(.pbix)? The question is whether it is concentrated in one report or all reports are the same.
It is best if you can provide a screenshot of the issue, which will speed up the speed of solving the problem.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
