Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
5 years ago

Controlling filters from visuals

Hi,

 

I have a page with 2 visuals (illustrated in the Excel below). Visual 1 is a visual where i want to select values that are shown in Visual 2. However, the visual 1 has filters coming from the filters pane and i want these to be ignored in the Visual 2. How do i ignore the filters pane selections? 

 

For example, in the picture below, when i click Category 3, i want Visual 3 to show all category 3 values, including blank values. 

 

This visual has filters applied to it on the filters pane. When

4 Replies

  • Hi, CarlsBerg999 

    Please correct me if I wrongly understood your question.

     

    Visual 1 -> Instead of using Filter Pane, try to write a measure that filters out blank values + only shows subcategory5.

    For instance, something like below.

     

    measure for visual 1

    if ( selectedvalue (category) = category 3, calculate (yourmeasure, filters out blank values + only shows subcategory5 ), yourmeasure )

     

    Or, please share your sample pbix file's link, then I can try to have a look into it to come up with a more accurate solution.

     

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    Hi CarlsBerg999 ,

     

    You can try to put the Sub-Category column in the slicer, and then select the Edit interactions in the Format.

    Make visual 2 not filtered by the slicer. This will get the result you want.

     

    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.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    Hi CarlsBerg999 ,

     

    Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

     

    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