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êsCheck out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
99 | |
38 | |
37 |
User | Count |
---|---|
152 | |
125 | |
75 | |
74 | |
63 |