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 ...
Need Help
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