Forum Discussion

JWA___'s avatar
JWA___
Regular Visitor
4 years ago
Solved

Overriding slicers

I have a very simple model: 1 dim table: My_dim dim1 dim2 dim3 dim15   1 fact table: Date My_dim Nr 1-1-2022 dim1 5 2-1-2022 dim2 20 1-1-2022 dim3 50 ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi JWA___ ,

     

    When you select a value (e.g. "dim 1"), the measure will only return 105 for the "dim 1" row, and the other rows will be blank. At this point Power BI will hide the rows with blank values by default. You can check "Show items with no data" to show the hidden rows. 

     

     

    You can also change the measure to the following formula.

     

    Measure 2 = CALCULATE(SUM('Fact Table'[Nr]), ALL('Dim Table'))

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi JWA___ ,

Not sure if I follow what you are trying to do, however to override a slicer, you can use the Format/ Edit Interactions as I have done below.  The table on the right is turned off, so it shows all, and the card on the left is left on, so it only shows the selected value.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

 

JWA___'s avatar
JWA___
Regular Visitor
4 years ago

This is not what I want to achieve, 
I want to do something similar als described in this blog post. But if I do what I described here for my dim table instead of the date table in the article, it doesn't work.....
https://dax.tips/2020/02/05/overriding-slicers/