Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter context

Hi,

I am trying to filter a visual by a different level than what is being displayed.  For example:

I have a bar chart which shows total population for all US states.

But I actually only want to include population numbers for those states which have cities that have a population of at least 500.

Also please note that I am using a live connection so I am unable to access the query editor.

Thanks!

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous how does your data looks like? Solution will depend on it. is population by city already in the dataset or it is a calculated measure?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I have population and city on a row basis.  It's not yet grouped in the dataset.  I believe population is a column, not a measure.

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    Anonymous 

    Please refer the below snippet for reference.

     

     

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

    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?