Forum Discussion

AlexS0902's avatar
AlexS0902
Frequent Visitor
1 year ago
Solved

Matrix visualisation - Unable to drag a column into values section

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....
Need Help
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago

    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 |

uzuntasgokberk's avatar
uzuntasgokberk
Icon for Super User rankSuper User
1 year ago

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's avatar
    AlexS0902
    Frequent Visitor
    1 year ago

    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's avatar
      uzuntasgokberk
      Icon for Super User rankSuper User
      1 year ago

      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 |