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
dz1996
New Member

Static line in "line and clustered column chart"

Hello,

 

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.

1 REPLY 1
Greg_Deckler
Super User
Super User

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: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.