Hi,
I have a pivot table that compares ratios for 20+ companies. I am using slicers to view one ratio at a time in a pivot chart (column chart) to see where my company lies against its peers.
However, I would like to visualise the data from largest to smallest in the pivot chart for every ratio I select. Unfortunately, I am unable to figure this out - reaching out to myonlinetraininghub for assistance on this.
Thanks in advance for any help I can get on this.
Hi Mynda,
I am attaching my sample workbook for your reference. In the sheet where the chart is, I have the ratio Book Vale / Share in descending order since I applied the sorting to the pivot table. However, when I select any other ratio it will be in the order of the companies as per the Book Value / Share sorting, and not in descending order of values.
Would there be a way I could select any ratio in the slicer and the chart displays the data in descending order.
Look forward to hearing from you.
Sarah
Hi Sarah,
Thanks for sharing your file. The problem is caused by the wrong structure of your Ratios data. You have a partially pivoted dataset and it should be in a tabular format. I explain this in my PivotTable video tutorial and how to fix the layout with Power Query's Unpivot.
When your data is in the correct layout the sorting in the PivotTable can be employed - see file attached, Tabular Data sheet.
I hope that points you in the right direction.
Mynda
