Forum Discussion
Line Graph has dots?
Hi Twinkie124,
Can you share the pbix file? Which visual is it? Seems there isn't a line existed.
Best Regards,
Dale
I wasn't sure how to share the pbix file on here...Sorry I am new to Power BI and this forum. I shared the data source with Onedrive in my first post, and you can download that and setup the pbix file yourself the way I showed? I was using the area chart. If there is an easy way to share the pbix file, I will gladly do that!
Hi Twinkie124,
You did the right way to share a file. But it seems unavailable. Could you please upload it again? Please mask the sensitive data first.
Best Regards,
Dale
Here is the regenerated shared onedrive link for the .pbix file and the Excel file.
Hi Twinkie124,
The root cause is that many values don't exist in the context even as a 0. We need to bring them in though they are 0s. Please check out the demo in the attachment.
1. Create a new table and establish a relationship.
Hours = VALUES(Sheet1[LOCALHOUR_INTEGER])
2. Create a new column like below and set its format as the snapshot shows. Why? Because the date hierarchy introduces new context.
Date = [LOCALINTERVAL].[Date]
3. Create a measure. I used 200 in the demo to show the effects clearly.
Measure = IF ( ISBLANK ( SUM ( Sheet1[Value] ) ), 0, SUM ( Sheet1[Value] ) )
4. Result is as follows.
Best Regards,
Dale