Forum Discussion
Solved
Include missing days in a line chart
I have a line chart that is displaying the total number of logins for each type of user each day. However, on weekends no users login to the system and therefore there will be no data for the weekend...
Hi Seanan ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure = IF( MAX('Table'[logins])=BLANK(),0,MAX('Table'[logins]) )2. X axis – Type – Categorical in Format.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Seanan ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure =
IF(
MAX('Table'[logins])=BLANK(),0,MAX('Table'[logins])
)2. X axis – Type – Categorical in Format.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous Thank you for the help! It worked great 🙂
