Forum Discussion
Full graph without scroll bar?
I am pulling in from a golden dataset, so I am not the creator of this data. I am unable to edit the dates datatype but it appears to be "text". Would I need to go into the master data to edit this or is there anyway to create a new date varaible from the exisiting one and change the type?
There should be a drop-down list where you see "text". Try selecting "Date" from it. If you are unable to convert it to a date, then yes you would need to create a new data variable from the existing one.
How do I create a new variable from an existing one?
Probably the simplest way to do it is to create a column from example in power query. This article should show you how to get started with it: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-add-column-from-example