The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
Columns being used:
Ruling filter on the page:
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
85 | |
75 | |
52 | |
44 |
User | Count |
---|---|
140 | |
113 | |
73 | |
64 | |
62 |