Forum Discussion

TA9's avatar
TA9
Frequent Visitor
3 years ago

filtering data, keeping some options always selected

Hi,

 

I am using the Census 2021 data and have created a file with ward, regional towns, region and England level data in order to compare the different geographical areas. All the geographical areas are in the same field (but I can change the underlying data format if needed)

 

My aim is to keep England, region, and town static and have a filter so the user can select a ward and the visual (e.g. bar graph) only updates the ward information.  In Excel, I could create a table of England, region and town data as static and then have a vlookup for the ward level data to change based on the filter... how can this be replicated in Power BI?

 

For example:

DeprivationEnglandRegionTownWard Selected (This will change)
Does not apply0000
Household is deprived in four dimensions5497019731284
Household is deprived in one dimension784269039478020394811
Household is deprived in three dimensions86810453831351735
Household is deprived in two dimensions332057819080010816258
Household is not deprived in any dimension11349743534296254071326
Grand Total234360851175680602622434

 

Any ideas?

 

Thanks.

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    My aim is to keep England, region, and town static

    So you will only ever have users from that one town?

  • TA9's avatar
    TA9
    Frequent Visitor
    3 years ago

    Yes, so town, region and country will remain static and ward will change

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      Better test that UX with a real user. They may not like that.