Forum Discussion

202321's avatar
202321
Regular Visitor
2 years ago

Power BI column chart visual keep one column constant/slicer only apply to one column

My report shows data about relevant geographies and a variety of different indicators. I have a slicer on the whole page to change the geography, e.g. london, birmingham etc. 

I have a column chart visual that I want to display England figures/data and then the lower geography (city) that the slicer dictates for the page, but I can't seem to find a way to make sure the England column stays constantly while also allowing for the slicer to change the lower geography. 

 

I tried following this forum solution: Solved: How to keep one column constant irrespective of fi... - Microsoft Fabric Community but it didn't seem to work and just breaks the visual. 

 

Is there a way to do this? I'm relatively new to Power BI so dumb it down for me if you can! Thanks.

Need Help

3 Replies

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    You can create a measure that ignores filters and slicers using ALL() in your DAX measure (use ALL to remove filters, then apply the specific ones you want to keep in your measure, or use ALLEXCEPT()). https://learn.microsoft.com/en-us/dax/all-function-dax 

     

    So you'd have two measures, one for the one you want to be static and one for the one you want to behave normally. 

     

    It's kind of hard to tell exactly what you mean from your description though so not sure if this applies?

    • 202321's avatar
      202321
      Regular Visitor
      2 years ago

      Thanks for your reply! 

      I've tried having a go at what you mentioned but can't seem to get it to work. 

       

      So essentially I have a column chart that is trying to show the % of people with qualifications of level 4 (degree) and above. I want the column chart to always show Englands %, and then show the county that is applied to the report page with the slicer. But I can't find a way to make England's column stay there permanently while the lower geography changes with the slicer. 

       

      Any more help you could give would be greatly appreciated! 

       

      Thanks