Pivot

%3CLINGO-SUB%20id%3D%22lingo-sub-1738418%22%20slang%3D%22en-US%22%3EPivot%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1738418%22%20slang%3D%22en-US%22%3E%3CP%3EHallo%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20prepare%20Pivot%20table%20for%20the%20assets%2C%20but%20I%20have%20a%20real%20problem%20with%20the%20chart.%26nbsp%3Bin%20the%20first%20column%20I%20have%20a%20date%20and%20in%20the%20next%20I%20need%20exact%20data%20on%20the%20close%20price%2C%20always%20falling%20below%20a%20specific%20date.%20In%20the%20value%20section%2C%20however%2C%20I%20can't%20set%20it%20so%20that%20the%20value%20is%20always%20equal%20to%20the%20one%20from%20Power%20Query.%3CBR%20%2F%3ECan%20anyone%20help%20me%20how%20to%20edit%20this%20Pivot%20Table%3F%3CBR%20%2F%3Ewell%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1738418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hallo, 

 

I am trying prepare Pivot table for the assets, but I have a real problem with the chart. in the first column I have a date and in the next I need exact data on the close price, always falling below a specific date. In the value section, however, I can't set it so that the value is always equal to the one from Power Query.
Can anyone help me how to edit this Pivot Table?
well thank you

 

 

2 Replies
Highlighted

@luci98 

Since it is asking for credentials which I don't have so cannot edit the Power Query.

But make sure that the data type of the numerical columns are set to decimals before the table is loaded back to the sheet, right now they seem to be Text.

@luci98 

Hi there,

I solved your issue and attaching to this message.

You should pay attention to data types while transforming them.

I changed Date data and Decimal Number Types using "Using Locale".

At the end, I added one column under the name of Company using M Language Text.Insert Function. Later, I appended all three tables.

After getting output in Table Format, I made two Pivot Tables separately on one sheet, and two chart with Slicer on another sheet.

I strongly believe that it can be solution to your issue.

If you consider this solution as best one, please mention it.

Good luck.