Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Doliveira
Frequent Visitor

Line Chart Label shows weekends entries

Hi,

 

After solve the problem reported at the post Line Chart by date my chart are showing the weekends entries when I filter the axys "Date" as "Relative data filtering" > "In the last" > "15 days" and also large intervals of date (ex. 23/07 > 30/07). 

 

How do I fix the weekends entries and shows all the days related to the counts applied as values?

 

Ps. My table Date already have all the business days.

 

Tks

1 ACCEPTED SOLUTION

Hi @Doliveira,

 

On the X-Axis option check if you have continuous or categorical option, change from one to the other should do the trick.

 

regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

Hi @Doliveira,

Of you have bussines days in your table add a visual filter with the businnes day and filter out all the nom bussines days.

Regards,
MFelix

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi @MFelix

 

I've done what you said, select only the business days, but the chart still shows a gap between 28/07 and 31/07.

Hi @Doliveira,

 

On the X-Axis option check if you have continuous or categorical option, change from one to the other should do the trick.

 

regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Now the x-axys shows only the dates that have numbers to show. Thanks for the help!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.