Forum Discussion
Power BI. Need support
I am sorry this suggestion is not helped me.
This is for reference. I want to show the zero for the missing week. Here i am pulling the value as Activity name column which is string and i directly pulling the call in the Value field and it is automatically convert to count. This activity count is mapped with Week number column from calender table
Hi Dhairya, Thankyou for your kind support. Also for your quick reference i have attached the screen shot that the suggestion which is given to me is applied but still i am not getting the zero value for the missing week.
Note: The weeknum is pulled from calender_table which has relationship with Monthly_data table (Y-Axis). Where i do have the activity_Names which i pulled to show the count of activity in the line chart. So here when there is no activity count for a particular week in the Montly_data table that week in the calender_table(X-Axis) should show as zero.
Hope you understand the logic.