Pie Chart Show Top 5, but after selection it show all in table

[Applicable88]

Hello,

i have a pie chart with where I use the TOP N option in the filter panel to show me TOP 5 products with most errors. 

When I select a category to see every row single product in a table, it is not showing all products of that category, but the already 

filtered ones from the TOP N of the pie chart. 

How to carry over the category selection, but ignore all other filters, which might been set?

Cheers.

Best. 

[v-yalanwu-msft · Accepted solution]

Hi, @Applicable88 ;

You can create a measure and apply it to Filter on Visual.

method 1:

create a flag measure.

flag1 =
IF( MAX([Sub]) in  SUMMARIZE( TOPN(5,ALLSELECTED('Table'),[value],DESC),[Sub]),1,0)

Then apply it into pie chart.

Method 2:

flag2 = RANKX(ALLSELECTED('Table'),CALCULATE( SUM([value])),,DESC,Dense)

Then apply it into pie chart.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi, @Applicable88 ;

You can create a measure and apply it to Filter on Visual.

method 1:

create a flag measure.

flag1 =
IF( MAX([Sub]) in  SUMMARIZE( TOPN(5,ALLSELECTED('Table'),[value],DESC),[Sub]),1,0)

Then apply it into pie chart.

Method 2:

flag2 = RANKX(ALLSELECTED('Table'),CALCULATE( SUM([value])),,DESC,Dense)

Then apply it into pie chart.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please do not use Pie charts unless you show 100% of the data.  Using TOPN with a pie chart is highly discouraged.

[Applicable88]

@lbendlin can you explain why. 

[lbendlin · Accepted solution]

I already explained it. Pie charts imply that the entire data subject (100%) is represented. Any filters that you apply to that data subject will skew that perception and lead to the wrong insights.