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.
I am trying to plot an accumulative count. When one value is missing in the X-axis, it is replaced by the total value of the counting. I have been trying to fix this setting the VALUES() parameter. But when I do that I can not use the filters with more than one column. Is there something wrong in the following code?
N_acum= CALCULATE(sum(data[NumBills]);filter(ALLSELECTED(Data);data[MDays] >= max(data[MDays])))
N_acum= CALCULATE(sum(data[NumBills]);filter(ALLSELECTED(Data);data[MDays] >= max(data[MDays])); VALUES(data[ID]))
the structure of the data base is like that:
thank you in advance
Solved! Go to Solution.
I selected Mdays for Axis and N_acum for Line chart as below. Is it same as your chart?
BTW, what do you mean “one value is missing in the X-axis”?
Best Regards,
Herbert
Could you please provide your table structure and which columns/measures do you select in the visual chart?
I try to repro your problem according to your measure formula but have no success.
Best Regards,
Herbert
hi Herbert, I've already changed the original message.
thank you for your help
I selected Mdays for Axis and N_acum for Line chart as below. Is it same as your chart?
BTW, what do you mean “one value is missing in the X-axis”?
Best Regards,
Herbert
It work, I didnt't understand correctly the values parameter, sorry...
Thank you for your help
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 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |