matrix with columns of different data types

[FOXYBARK]

Hello. 

Is it possible to have a matrix containing columns of different data types? Example pictured. Everything i've read states a single column in the dataset has to be one data type only. Please advise if this can be done. An example or link to an example would be great. Also, another caveat is my data is spread across 2 different tables. 

Thanks

[v-hjannapu · Accepted solution]

Hi @FOXYBARK,

I would also take a moment to thank  @danextian , @MasonMA, @selimovd for actively participating in the community forum and for the solutions you have been sharing in the community forum. Your contributions make a real difference.

Yes, you can create a matrix with columns showing different data types like numbers, dates, and text just add each field separately in the Values area. If your data is split across two tables, make sure there's a relationship between them using a common key like ProductID.

I tested it with my sample data, and it worked fine. Please find the attached screenshot and Pbix for your reference.

Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
Best Regards,
Harshitha.

[danextian]

Hi @FOXYBARK 

A column can be a single data type only. While you can have type any (denoted by ABC123 icon), it is essentially treated as a text string and in effect can  alow text-related aggregations only.  Are those measure columns in  your screenshot a single column in the table with different categories or are they separate columns?  If the latter, each can have its own data type but basing on the screenshot they're either type number or interger. If the former, they need to be shaped so each category has its own column or you can use dynamic format strings. Which approach to follow depends on the structure of your actual raw data. 

[MasonMA]

Hi @FOXYBARK 

In addition,  you would need to transform your Data in Power Query and normalize your data first.

Convert those numeric/date values to text using Text.From() in Power Query to support mixed types.

A matrix with columns that appear to have different data types, because you controlled their content as text representations.

Hope this helps:) 

[selimovd]

Hey @FOXYBARK ,

yes, columns can be from different data types.

Just drag them into the visual.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Connect with me: LinkedIn