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 ?