cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Date visualization show date which is no "value"

1st.PNG2nd.PNG3rs.PNG4th.PNG

 

Hi everyone, 

I'm getting few problems over BI , 
*1st and 2nd pics : the graph looks correctly and nice but didn't rang the date by Order . While i create relationship between Fact table and  Date Table. those look proper and nice as purpose due to i Changed from Date/Time to Text format in "Best Before" table. But look at the Visualization. The date is not rang by the order which is not my objective result. 

*3rd and 4th pics :  I change format of "best before" column from Text to "Date Format". Look at the date are well ranking which is what i'm looking for. But look at the graph so messy and narrow. because it also visualize the date which is no Value which is not what i want. 
Do you have any idea how to fix this ?

Thanks with Regards, 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: Date visualization show date which is no "value"

Hi @Chanleakna123,

 

1. You can use the function "Sort by column" to order the dates. Date visualization show date which is no value.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

2. That's because your data have a large span of dates from 2016 to 2022. If you want larger bars, the visual could be very large. 

1) Please try to filter down to a narrow data span.

2) Please try Categorical X-axis.

 

Date visualization show date which is no value2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-jiascu-msft
Microsoft

Re: Date visualization show date which is no "value"

Hi @Chanleakna123,

 

1. You can use the function "Sort by column" to order the dates. Date visualization show date which is no value.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

2. That's because your data have a large span of dates from 2016 to 2022. If you want larger bars, the visual could be very large. 

1) Please try to filter down to a narrow data span.

2) Please try Categorical X-axis.

 

Date visualization show date which is no value2.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Microsoft v-jiascu-msft
Microsoft

Re: Date visualization show date which is no "value"

Hi @Chanleakna123,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors