Forum Discussion

zeitgeist's avatar
zeitgeist
Regular Visitor
7 years ago
Solved

Funnel Chart with filtered months

Hi, I am a bit new to PowerBI but not to charts, dashboards in general. I have the following table format:   Date Accessed Purchased Paid 01/01/2018 526 91 50 02/01/2018 823 164 7...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

zeitgeist's avatar
zeitgeist
Regular Visitor
7 years ago

Hi, thanks for the answer.

 

unfortunately I stoped right at the start. It returned error on the Date.toText function:

 

A sintaxe de '.' está incorreta. (DAX(Date.ToText([Date],"MMMM"))).

Just to be sure, since I am new to powerBi, I  entered the Data view, selected my source with the table I sent before, right clicked on it and clicked on the "New Column" item.

 

Is that correct?

 

Thanks

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi zeitgeist,

 

Now in the data view pane. Please check the steps as the picture as below.

 

Edit Queries - add custom column - enter the formula.

 

 

Regards,

Frank

  • zeitgeist's avatar
    zeitgeist
    Regular Visitor
    7 years ago

    Hi Everyone.

    Sorry for the lack of answers but I am away from work these days so I don't have access to the original files. I will get back and try the solution until Friday.

     

    Thanks for the help!