Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create a custom slicer?

Hello   I have repeatedly asked for some clarity on how to create a custom slicer but I get answers that are not self-explanatory.  Please if you don't want to describe ALL the steps to achieve th...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    You can filter the value in the filter panel with measure =1, like below:

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

 

1. You can use the same column in the slicer and select the required string.

2. Click on "New Table" and use the below code to create a new table contains "A" or"B" then establish a relationship with your data and use this new column as a slicer.

SlicerTable = UNION(row("Slicercolumn","a"),row("Slicercolumn","b")).
3. Import "Slicervalues" from excel then establish a relationship and use imported column in the slicer.
 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad