Forum Discussion

StephenGW's avatar
StephenGW
Helper II
5 years ago

Convert Month text to Date

I have a line chart that goes by months. The problem is the months are full month text January, February, ect. The data is linked to an Excel file in my OneDrive so there are no tables in my Power BI...
Need Help
StephenGW's avatar
StephenGW
Helper II
5 years ago

HotChilli 

 

I don't have any tables "IN" my BI. They are all a live connection to OneDrive so I can't add a column in BI. The spreadsheets are fed by a Power App so the table cannot contain any formulae. So adding a column is not as simple as I think it should be. I have read many articles like the one you posted but it says to add a calculated column into the table but I have not tables in BI.

 

Thank you for the suggestion and link but those are not an option. Do you know of any other ways this can be accomplished?

 

Stephen

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi StephenGW,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

  • StephenGW's avatar
    StephenGW
    Helper II
    5 years ago

    Anonymous 

     

    Thank you. I was unable to find a way to do this so I went about it the difficult way. I resturctured my Power App to use dates rather than just the text of the month name and then went back and changed all the old data into dates as well.

     

    Thank you for your time and help with this issues.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi StephenGW,

      You mentioned you are working with 'live connection' to these files. What type of data connector are you worked? How did you link to these files? Can you please share more detail about these?

      AFAIK, power bi also allows you to use a web connector to link to the file stored in onedrive or sharepoint. It will keep edit features and allow you to do more data model operations.

      Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs
      Regards,

      Xiaoxin Sheng

      • StephenGW's avatar
        StephenGW
        Helper II
        5 years ago

        Anonymous 

         

        That is a great link. I did not know about this option. I linked it through Get Data>Files>OneDrive for Business>Import. My question with the method mentioned in the link, how does that work with sharing? In order to share with everyone in my organization I had to put both the report and dataset in the preimum workspace as some users are free. Since the data will remain in my OneDrive and not in the premium workspace will it still allow me to share?

         

        Thanks,