Showing results for 
Search instead for 
Did you mean: 
dz1996 Occasional Visitor
Occasional Visitor

Static line in "line and clustered column chart"



I was wondering if there is a way to show a static line in a chart(line and clustered column chart) that's filtered by a Calendar(using a slicer). I have tried creating another measure linked to a second calendar, but the filter still affects both lines. The idea is to use it as the "total" line, to compare it with the progress for the range of dates specified by the Slicer.


Is there any way to do it?


Thank you in advance.

Super User
Super User

Re: Static line in "line and clustered column chart"

Sounds like you need to put an ALL in your measure calculation. Hard to say though.


Please see this post regarding How to Get Your Question Answered Quickly:

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Community Highlights

Community Highlights

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

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.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 402 members 4,228 guests
Please welcome our newest community members: