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 colleagues!
This is a very popular theme as I see. But I haven't found solution to my case yet.
So, I have this measure and line chart:
There is zero value on 1 May, but, as you can see, zero point is skipped in the line chart.
If I add +0 to the measure I will get:
Zero value on 1 May has appeared, but a lot of fake zero values (there are no zero values but all of them filtered by slicer) have appeared too. The line chart is getting to be inconvenient.
Hi @gerasimovav,
Could you please share some sample data to have a test if possible?
Regards,
Daniel He
Hello, @v-danhe-msft
It's quite easy. For example the measue is
Number of Orders = COUNTROWS(SENDING)
Where table "Sending" looks like
As you can see there are no rows with 01.05.2018 PO_CREATION
I put a slicer by PO_CREATION and filter by PO_CREATION beetwean 30.04 and 03.05:
As you can see there is no zero point point at 1 May. Line goes from 30 April directly to 2 May.
I need zero point in 1 May!
Now I change the measure to
Number of Orders = COUNTROWS(SENDING)+1
And get:
Zero point apeared but with a lot of fake zero data
Hi,
Share the link from where i can download your PBI file.
Hi @gerasimovav,
Based on my test, there is no record in the 2018/5/1, if you want to show 0 in 2018/5/1, it should have a row of 2018/5/1:
If your data do not contain the reocord in 2018/5/1, the visual will show by design and will not show a zero.
Regards,
Daniel He
What is your measure formula? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |