Matrix visualisation - Unable to drag a column into values section

[AlexS0902]

After months of using a Power BI report, I have come accross an issue where now I am unable to drag a simple column to the values section in a matrix table. I have been able to do this easily before. It's not a file specific issue as I've created new reports and tried the same thing.

Below is an example of trying to add a simple revenue column to the values section.

Any help would be much appreciated, cheers.

Alex

[uzuntasgokberk]

Hello @AlexS0902,

Your reveneu column seems like a string value and if you'd like to put your column into values in Matrix. The columns needs to be aggreated such as sum, avg etc.

İf you are sure your revenue is number values then you can change the type 
Example image:

Select your column and you can do it below the image.

Or you can change the type in transfrom data(Power Query).

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[AlexS0902]

Hi Gökberk,

Thanks for the response. The column is type Decimal number so should be able to be aggregated. Even if it was text I use to be able to add in a text column and it would aggreagte by using 'first'.

Currently to get around the issue I'm having to create a measure for every column I would limke to add.

Thanks

[uzuntasgokberk · Accepted solution]

Hello @AlexS0902,

According to your image there is no capital sigma icon near to Revenue. So if there is capital sigma icon means that it is aggreated. But you use as a text Power BI only understands that the column can be used only first, last, count. So if you want to use as a numerical value make it summarization as SUM, AVG etc. The other way is creating a measure that also means that best practice way.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |