Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
MattiaIngAir
Frequent Visitor

How to make some fields always shown, indipendently from the filters?

Hi to everyone!
I'd like to show in the visual named "line charts" a line made by some data that's always shown and fixed and then other lines that depends on filters (i.e. slicers). For example, I want to compare the price chart of a financial index on y axis, on the x axis the date but I also want to show the options available on that index, that has to change accordingly with some slicers. So I want the chart of the index fixed on the visual e the price of the options being variable. The values of the prices (both for index and options) are in the same column and are split using the legend. I tried a lot of different solutions, but nothing worked. I am open to every solutions available, even modify the way the data are structured would be ok.

1 REPLY 1
djurecic
Super User
Super User

Hi @MattiaIngAir ,

 You can create a measure with the ALL function for a value that is independent of slicer selections.

https://learn.microsoft.com/en-us/dax/all-function-dax

 

https://dax.guide/all/#:~:text=ALL%20DAX%20Function%20(Filter)

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.