Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Keepfilter Not working

whenever I use Keep filter as well as Filter . It is not showing blank values with the existing filters. Just the new filtered value. Please tell me, what I am doing wong?

  • Hi Anonymous 

    By default, Power BI visuals will hide combinations of fields for which all measures included in the visual are blank.

    As you've mentioned, with the visual you have created, [Measure] evaluates to blank for all countries except France (which is as expected).

     

    In order to force the visual to display those countries where [Measure] is blank, right-click Country in the field well, and select "Show items with no data".

    Regards,

     

     

2 Replies

  • Hi Anonymous 

    By default, Power BI visuals will hide combinations of fields for which all measures included in the visual are blank.

    As you've mentioned, with the visual you have created, [Measure] evaluates to blank for all countries except France (which is as expected).

     

    In order to force the visual to display those countries where [Measure] is blank, right-click Country in the field well, and select "Show items with no data".

    Regards,

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks owen. I was racking my brain over this all day long wondering what I did wrong in the formula. Cheers👍