Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Ignore Slicer in rows

Hello,

 

I have a column with some KPIs, for example:

 

ColumnName

A

B

C

D

F

 

I just want to show a table with A, B, C and with no respect of a slicer with the choices A, B, C.

 

I tried to create a new table like:

 

TabelleNew =
CALCULATETABLE (
ADDCOLUMNS (
ALLSELECTED(Table[KPI]),
"Min", [value_min],
"Max", [value_max]
),
Table[KPI] IN { "A", "B", "C"}
)
 
It ignores the slicer but the value_min and value_max is not right yet. I suppose here value_min and value_max should respect Table[KPI].
 
Thanks.
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Pikachu-Power 

     

    I think you have worked out a good solution. As a calculated table will not be affected by a slicer, it's good to create a new table to have the values you want. 

     

    Another practice is that you can turn off the visual interaction between a slicer and a table visual. Select a slicer in the report, go to Format ribbon > Edit interactions. You will see how this slicer influences other visuals on the same page. You can turn off the filtering bahavior on other visuals if you don't want them to be filtered by the slicer. Change how visuals interact in a report - Power BI | Microsoft Docs 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Pikachu-Power , A calculated table, can not use slicer value.

     

    Only a table inside measure as Var can use slicer value. But you have to that in each measure

    • Pikachu-Power's avatar
      Pikachu-Power
      Icon for Impactful Individual rankImpactful Individual
      4 years ago

      Sorry i didnt get that 🙂 How would the formula look like?

       

      Maybe not the best way but I created the same table again with SELECTCOLUMS and write all measures (Min, Max and so on) again in this new table. Than it ignores the slicer of the first table. 

       

      But maybe soneone knows a more elegant way to do that?

      • v-jingzhang's avatar
        v-jingzhang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Pikachu-Power 

         

        I think you have worked out a good solution. As a calculated table will not be affected by a slicer, it's good to create a new table to have the values you want. 

         

        Another practice is that you can turn off the visual interaction between a slicer and a table visual. Select a slicer in the report, go to Format ribbon > Edit interactions. You will see how this slicer influences other visuals on the same page. You can turn off the filtering bahavior on other visuals if you don't want them to be filtered by the slicer. Change how visuals interact in a report - Power BI | Microsoft Docs 

         

        Best Regards,
        Community Support Team _ Jing
        If this post helps, please Accept it as Solution to help other members find it.