Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to Solution.
Hi @Chanleakna123,
1. You can use the function "Sort by column" to order the dates.
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.
Best Regards!
Dale
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
Hi @Chanleakna123,
1. You can use the function "Sort by column" to order the dates.
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.
Best Regards!
Dale