Forum Discussion
rahuldas_vgm
Helper I
Helper IHow to show top 10 values without changing their calculated values
Hello everyone, I have a matrix visualization which contains 8 months data. When I select the month in slicer, I get the data I want to show. But, when I apply TopN filter the %age calculated mea...
rahuldas_vgm in this case, there is workaround, you can create a table having topN values
in this case, we have assumed you want to have only top3 value which you can change as per your needs
Table_Top_value =TOPN(3,VALUES(sales_tab[Branch]),calculate(sum(sales_tab[Sales])))then you can create a calc column in your main table like below to group top and non top valuesIn_Top = if(isblank(LOOKUPVALUE(Table_Top_value[Branch],Table_Top_value[Branch],sales_tab[Branch])),"not in top3","top3")then in your visual, you can apply a filter to show only topN values, below is the expected output
i am attaching pbix file as well. thanks.
negi007
Community Champion
Community Championrahuldas_vgm in this case, there is workaround, you can create a table having topN values
in this case, we have assumed you want to have only top3 value which you can change as per your needs
Table_Top_value =
TOPN(
3,
VALUES(sales_tab[Branch]),
calculate(sum(sales_tab[Sales]))
)
then you can create a calc column in your main table like below to group top and non top values
In_Top = if(isblank(LOOKUPVALUE(Table_Top_value[Branch],Table_Top_value[Branch],sales_tab[Branch])),"not in top3","top3")
then in your visual, you can apply a filter to show only topN values, below is the expected output
i am attaching pbix file as well. thanks.