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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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