Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Visual Filter not woking as expected

Hi All,   I am new to PowerBI and I am trying to achieve a particular logic with multiple charts. I'm in the half way but stuck in one position. Here's the problem.   I've two bar charts. Each o...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Everyone, 

     

    I am able to resolve this issue, by using Cross Filtering feature available in Feb 2019 PowerBI desktop release. Using this feature you can choose either you want to Cross highlight or Cross Filter your charts based on the selection. This option will available when you click on the "Edit Interactions" button under the Format ribbon just like the below.

     

    Cross Highlight-Cross Filter Icons

     

    By default, it would be Cross Highlighting, you can change it to Cross filtering by clicking the above "chart and filter" icon, then the chart will get filtered based on the other selection.

     

    For me it worked. In my chart it was highlighting 4 bars instead of 1 because of a grouping query. That gets filtered out and only one bar which is expected, popping up based on the selection.

     

    Anyway, thanks everyone for your time and effort. Hope I explained it clearly so that it would help others in the similar situation.

     

    Thanks again!

     

     

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

Modify measures like patttern below and check if they can work:

ByHTypeValue =
DIVIDE (
    CALCULATE ( SUM ( 'VW_MODEL'[TotalValue] ), ALLSELECTED ( 'VW_MODEL'[Xaxis1] ) ),
    CALCULATE (
        SUM ( 'VW_MODEL'[TotalValue] ),
        ALLSELECTED ( 'VW_MODEL'[Xaxis2)) +  CALCULATE(sum('VW_MODEL'[TotalValue] ),
        ALLSELECTED ( 'VW_MODEL'[Xaxis1] )
    )
        + CALCULATE ( SUM ( 'VW_MODEL'[TotalValue] ), ALLSELECTED ( 'VW_MODEL'[HType] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-yuta-msft 

     

    Thanks for looking into. I really appreciate it. But that didnt really help. 

     

    I'm facing this issue because I used a logic to get the group total based on Xaxis1. Due to that when I click on any part of the bar chart, the below chart incorrectly highlights. 

     

    Either, I have to use a different DAX query logic to get the group total. (i.e., the sum of Xaxis1 group to 100%. It means all 1's summed to 100%, all 2's summed to 100% and so on.)

     

    Or, I need to edit the code which triggers while clicking on the chart (I dont even know that's possible or not) to choose the partcular bar based on Xaxis1 and Xaxis2.

     

    Hope you understood the issue better. Any help would be appreciated.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Everyone, 

       

      I am able to resolve this issue, by using Cross Filtering feature available in Feb 2019 PowerBI desktop release. Using this feature you can choose either you want to Cross highlight or Cross Filter your charts based on the selection. This option will available when you click on the "Edit Interactions" button under the Format ribbon just like the below.

       

      Cross Highlight-Cross Filter Icons

       

      By default, it would be Cross Highlighting, you can change it to Cross filtering by clicking the above "chart and filter" icon, then the chart will get filtered based on the other selection.

       

      For me it worked. In my chart it was highlighting 4 bars instead of 1 because of a grouping query. That gets filtered out and only one bar which is expected, popping up based on the selection.

       

      Anyway, thanks everyone for your time and effort. Hope I explained it clearly so that it would help others in the similar situation.

       

      Thanks again!