top 3 values per week year, 1 column per category

[Fraizerrrrr]

show only the top 3 category values on pie chart , I cant used TopN. Each category have different column. 

[Fraizerrrrr]

[v-xinruzhu-msft]

Hi @Fraizerrrrr 

Can you provide more sample data and the output you want ? the data you have provided only display the part, but it does not contain category or other.

Best Regards!

Yolo Zhu

[Fraizerrrrr]

I want the table show only the top 3 highest value when I click the slicer for year, machines, and any column from bar chart that represent the week number. Each values consist of different column.

[v-xinruzhu-msft]

Hi @Fraizerrrrr 

You mean there are multiple columns, and the three columns with the highest values in those columns are returned, right? 

Best Regards!

Yolo Zhu

[Fraizerrrrr]

yes, I only want that top 3 to show what ever column that is the highest in every click, is it possible? 

[v-xinruzhu-msft]

Hi @Fraizerrrrr 

it cannnot implement directly, if you want to implement this, you need to unpivot the table first to set the multiple columns to two columns "Attribute" and "Value", you can refer to the following link.

Unpivot columns - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fraizerrrrr · Accepted solution]

It says an error occured