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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lucassilva2703
New Member

Ignore filter context minus date

Hello, I have a problem, can you help me?

I have a graph of grouped columns and rows, and I am putting on my secondary Y axis the measure 'targetss" which should return me a straight line, but because of the filter context it brings a crooked line.

the use of all and allselecetd were not so good, as they returned my entire data period, and I only want "this month".
I tried this dax

Targetsss =
CALCULATE([Weighted PPH Target], FILTER(ALL(dDate_Periods), dDate_Periods[Period] = "This Month"))

But it doesn't succeed, it still returns the total context.

Look at the example below:

Chart:

 
'1.PNG

Columns being used:

Lucassilva2703_0-1696938259766.png

 

Ruling filter on the page:

Lucassilva2703_1-1696938296700.png

 

1 REPLY 1
MFelix
Super User
Super User

Hi @Lucassilva2703 ,

 

What is the value of "This Month" is a column with the current month on your calendar table?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

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