Forum Discussion

rahuldas_vgm's avatar
rahuldas_vgm
Icon for Helper I rankHelper I
4 years ago
Solved

How 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...
Need Help
Tips and Tricks
Tutorial Requests
  • negi007's avatar
    negi007
    4 years ago

    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 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.
     
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Could you share the download link of your PBI file?