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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Line and Stacked Column Chart - Slicer Dependents

Is there a way to make just the line in a line and stacked column chart not dependent on slicers?  I want to compare data against the total average, not what is sliced.

 

When I filter down, it recalculates to the average within those filters.

1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

@Anonymous 

 

For the line, i suggest you create a measure (not column) and in the formula use the ALL, ALLSELECTED functions so as to ignore slicers.

 

A good link is the following:

https://www.sqlbi.com/blog/marco/2010/04/05/all-allexcept-and-values-in-dax/

 

Then add this measure to the graph

View solution in original post

1 REPLY 1
themistoklis
Community Champion
Community Champion

@Anonymous 

 

For the line, i suggest you create a measure (not column) and in the formula use the ALL, ALLSELECTED functions so as to ignore slicers.

 

A good link is the following:

https://www.sqlbi.com/blog/marco/2010/04/05/all-allexcept-and-values-in-dax/

 

Then add this measure to the graph

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.