Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello ,
Im struggling with a line chart report , my target is to display the result between march 2020 and march 2021 , I used this request :
LA = CALCULATE([ID INCIDENT(No Blank)],DATESINPERIOD(ExportSM9[ConvertDATEOUVE],DATE(2020,3,1),13,MONTH))
But I still have the results between Jan2020 and December 2021
My result is :
Thnak you
Hello
Can you try again? I can't insert it here directly, I changed the permissions
Thank you
owe
Hello
Can you try again? I can't insert it here directly, I changed the permissions
Thank you
owe
Hello
Can you try again? I can't insert it here directly, I changed the permissions
Thank you
owe
Hello
Can you try again? I can't insert it here directly, I changed the permissions
Thank you
Should
hello,
can you try again? I can't insert it here directly , I changed the permissions
Thank you
Rim
HI @RIMMIMI
It looks like either your DAX query doing zero handling because of measure you have created or your dataset having entry for the same.
In new page just drag this measure in table visual with all required column and check if data is coming till december 2021 or not . If it is coming with 0 value then measure need to be corrected.
Thanks
Hello ,
I had a matrix before transforming it to a chart line , indeed the values after march are 0, because my data stop at march 2021, I dont understand why it continues until december 2021
Hi, @RIMMIMI
If it is OK with you, please share your sample pbix file, then I can try to have a look and come up with a desirable solution.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hello
I shared with you but It seems that you didn't see it thank you
@RIMMIMI , does this measure uses +0 or handle is blank
[ID INCIDENT(No Blank)]
refer, +0 in the first var can give all dates. So I handled that remove dates again
0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
thank you for your reply , but it didn't work , should I create a unique DAX or create the VARs and make the Calculate Fonction alone ? thank you
Hello ,
Thank you , I dont know how to send you my pbix tell me how plz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |