Forum Discussion

Rnkoerner's avatar
Rnkoerner
Copper Contributor
Jul 23, 2023
Solved

Pivot chart

I am creating a pivot chart from a master sheet of data. The column I am using has 20 characters, I need to only show the first 10 characters. I believe I need to add a measure but I can't get my DAX...
Charting
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 23, 2023

    Rnkoerner Why DAX? Connect to the data with Power Query, Add a column that extracts the first 10 characters. Set the data type to Date, load to the Data Model and use that 'date-only' column in the pivot table/chart. 

     

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2023

Rnkoerner 

I guess you use that field as label, not as value. In data model you may add calculating column (not measure) as

=DATEVALUE( LEFT( Table1[Date], 10 ) )

and work with it. In any case you need to transform it from text to date.

Or do the same with Power Query as Riny_van_Eekelen suggested.

 

 

Resources