topic Re: How to use Column with Text datatype in matrix ? in DAX Commands and Tips

How to use Column with Text datatype in matrix ?

WillemM — Tue, 31 May 2022 09:28:17 GMT

Hi,

Maybe someone can point me in the good direction with this issue.

In my datamodel i have "table 1" (see screenshot below).

What is the problem ?

The column "Eigenschapnaam" consists of multipe distinct values (hundreds...)
Column "Waarde" has datatype "Text", but as can be seen the rowvalues consist of text, numbers, currency and dates .

In my report i need a matrix in which i can present the numbers as numbers (and total), dates as dates etc.

The "Zaakidentificatie" is on the rowlevel in the matrix and with a slicer a can select the "Eigenschapnaam" to present in the columns. (succeeded but not in the right format)

Is it possible to present the values in the right datatype for each "Eigenschapsnaam" and how?

Thx for your help,

Wil

Re: How to use Column with Text datatype in matrix ?

Anonymous — Fri, 03 Jun 2022 07:48:15 GMT

Hi WillemM

I don't quite understand your needs, what does your "correct data type render value" look like? Can you show the results you want in the form of data or screenshots? It would be even better if you could attach your source data.

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to use Column with Text datatype in matrix ?

WillemM — Tue, 07 Jun 2022 07:19:14 GMT

Hi Ailsa,
After selecting (1 or multiple) "Eigenschapnaam" from the slicer needed in the matrix, the outcome should be like :

In the printscreen the "Waarde"(column 2 to 4) is always presented as "Text" . Column 2 and 3 should be "Numbers" and column 4 should be "Date".

Thx for helping.