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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

You will have to create a Calendar Table with all unique dates.  Create a elationship from the date column of both Tables to the Date column of the Calendar Table.  In your Calendar Table, write calculated column formulas to extract Year and Month by using =YEAR(Calendar[Date]) and =FORMAT(Calendar[Date],"mmmm").  In which ever visual you now create, drag Year/Month fields from the Calendar Table.

 

Hope this helps.

zeitgeist's avatar
zeitgeist
Regular Visitor
7 years ago

Hi, I tried the solution, but i don't think it worked.

 

I am inserting my dashboard here .

 

Basically I can't seem to interact the funnel with all the other views and the slicer.

 

Thanks

 

Dashboard

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    In this PBI file, when you change the month in the slicer, all charts will respond.  However, when you click on a slice of any Donut chart, the funnel chart will not response because there is no common/connecting column between the Analytics Funnel (2) table and the Plan1 (2) Table.