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
- Dhairya
Solution Supplier
Hey Bhaskar1986
Instead of plotting the Activity column directly, create the following measure and plot it
Number of Activities = COUNT('Table Name'[Activity name]) + 0
or
Number of Activities = COUNTROWS(TableName) + 0
If still you are facing issues then please share sample input data and expected output. and if it works then please mark my solution as accepted and kudo the post so that others can find it quickly while facing a similar issue. Thank You! 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.
