cancel
Showing results for
Did you mean:
Regular Visitor

## Re: Average and individual account lines on line graph

I'm still a little confused. If I change the axis on my graphs to the date from the date table, my overall line is no longer an overall line -- it is sliceable by color.

I'm looking for a way for my overall lines to be affected by the same date slicer (now from the date table), but not by color )from it's own color table).

Super Contributor

## Re: Average and individual account lines on line graph

Hi @swong,

According to my test, it didn't filtered by color. You can see it from the table visual. Please reference: https://1drv.ms/u/s!ArTqPk2pu-BkgQpsa9nmJlIOhVqQ.

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average and individual account lines on line graph

I see -- yes, the color slicer does not affect the overall line, but the overall line doesn't change when I apply the date slicer. Is there a way to change it with the date slicer?

Thanks,
Serena

Super Contributor

## Re: Average and individual account lines on line graph

Hi Serena,

I found out the trick after re-research "All" and "Allexcept". Try this formula please. The fields of the slicers should com from table 'date' and table 'color'.

```Overall =
CALCULATE (
AVERAGE ( Sheet1[Revenue] ),
ALLEXCEPT ( 'Date', 'Date'[Date] ),
ALL ( Color )
)```

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Average and individual account lines on line graph

I see, that works for color!

Is it possible to make my graph affected by multiple slicers? e.g. color AND location. I tried adding my location table as an argument to ALL, but the ALL function doesn't take more than one argument.

Highlighted
Regular Visitor

## Re: Average and individual account lines on line graph

I played around a little more and figured out that for each slicer, I just need to have another ALL statement. Thank you so so much for your help!!

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 113 members 1,815 guests
Recent signins: