Forum Discussion

Bhaskar1986's avatar
Bhaskar1986
Frequent Visitor
2 years ago

Power BI. Need support

I want show zero for the week number were they dont have volume for the particular week in the line chart
Need Help
Bhaskar1986's avatar
Bhaskar1986
Frequent Visitor
2 years ago

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's avatar
Dhairya
Icon for Solution Supplier rankSolution Supplier
2 years ago

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!