Forum Discussion
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...
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.
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.
Riny_van_Eekelen thank you so much!!